Update Table Macro

H

Harvard

Does anyone know how to create a macro that checks to see if a certain value
is in a dropdown, and if not, opens the underlying table, adds the record and
refreshes the dropdown? I've been trying to do this for weeks. Any help
would be much appreciated!
 
S

Steve Schapel

Harvard,

As far as I know, this is not possible with a macro.

When you say "dropdown", I assume you are talking about a combobox. In
Access 2007, there are properties for comboboxes that allow you to
nominate a form to open for the entry of new items for the combobox's
Row Source. In earlier versions of Access, you will need a VBA
procedure on the combobox's Not In List event. There is information
about this at http://www.mvps.org/access/forms/frm0015.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
VBA word change keys 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Integrating information from Word to Excel (not mail merge) 1
Improving Macro That Keeps First Letter 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top