RE: [AccessDevelopers] Add to Dropdown without opening a form

[Lava Boggavarapu]

Forgot the double quote in the query.   SELECT SupplierName FROM Suppliers   UNION   SELECT “<New Supplier>” AS SupplierName ORDER BY SupplierName     Lava   ------------------------------------------------ Lava Boggavarapu Lava Trading Inc. 95 Morton Street New York, NY 10014   Tel 212.519.9371 Mobile 732.668.2935 www.lavatrading.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Lava Boggavarapu Sent: Thursday, January 05, 2006 2:03 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Add to Dropdown without opening a form   Try   SELECT SupplierName FROM Suppliers   UNION   SELECT <New Supplier> AS SupplierName ORDER BY SupplierName   As the source for the combo. (you may create a union query in Access itself).   When the user selects <New Supplier>, pop up a form to gather the new supplier’s info.   HTH.   Lava   ------------------------------------------------ Lava Boggavarapu Lava Trading Inc. 95 Morton Street New York, NY 10014   Tel 212.519.9371 Mobile 732.668.2935 www.lavatrading.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of lostfayth Sent: Thursday, January 05, 2006 1:57 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Add to Dropdown without opening a form   Ok I think this is an easy one but it's plaguing me... on a form (ProjectProfile)I have a dropdown/lookup called [Suppliers].  I am trying to make it easy to add a new supplier... any suggestions? PS I've tried opening the Suppliers form using a button but I get network errors...plus..      The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.