Update Table Macro

  • Thread starter Thread starter Harvard
  • Start date Start date
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!
 
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

Create MACRO for menu dropdown in WORD 1
setwarnings - message suppression 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Word Word 2010: help needed creating macro that cross references checkbox to a bookmarked drop down list 0
New macro doesn't update existing records 1
Access Automatically Send a notification email once a record is added 0
Conditional Step in a Macro 1
SendObject Macro 10

Back
Top