I want to open a data entry form when a user enters a value that isn't in the list of a combobox. I've tried putting this code in the OnNotInList event property of the combobox:
DoCmd.OpenForm "DataEntryForm",,,,acFormAdd, acDialog, NewData
But nothing happens. This should work, right? Does anyone have any ideas why it might not be working?
DoCmd.OpenForm "DataEntryForm",,,,acFormAdd, acDialog, NewData
But nothing happens. This should work, right? Does anyone have any ideas why it might not be working?