I have a field "Sender's Name" and the value is usually selected from the Sender table. But I want that if a name is not available in the sender's table, the Data Entry Operator can type and add the same. Pl. advise how to do it.
hksahoo
Novice
Windows 7 64bit 
Access 2007
I have a field "Sender's Name" and the value is usually selected from the Sender table. But I want that if a name is not available in the sender's table, the Data Entry Operator can type and add the same. Pl. advise how to do it.
hksahoo
VIP
Windows 7 64bit Access 2010 32bit
Record must be added to the Sender table. This can be accomplished 'on the fly' during data entry but will require VBA code in combobox NotInList event. Review: http://www.blueclaw-db.com/access_no...ed_example.htm
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Adding 1 year to a date field and autofilling to another field
Posting Permissions
Reply With Quote