ComboBox Programming Using After Update Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to create new item using after update event, also the combo box can using
to search the recorded records.
 
If the combo's bound column is *not* zero-width, you can use its NotInList
event procedure to add a new value to its RowSource table. Explanation and
code:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

If you are using a combo for selecting an item in a record and also for
navigating to another record, you have an interface that has confused two
different tasks. Consider using 2 different combos: one for entering a value
into the record, and another for navigating to a different record. For an
example of how to set up a separate navigation combo, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
Then, if you want to move to a new record when the value was not found, just
replace the line:
MsgBox "Not found: filtered?"
with:
RunCommand acCmdRecordsGotoNew
 
Back
Top