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
 
Back
Top