Hi there,
Hope that title wasn't too confusing. I really need help in writing an event procedure for the following form scenario:
On frmAddresses, after a postal code has been entered for a new address, I would like a field called 'Deliverylocation' to display the appropriate 'deliverylocation' Name, already assigned to that postal code, and write the 'deliverylocation' PK to the appropriate integer field in tblAddresses.
I have a table with 6000 postal codes and their appropriate deliverylocation IDs:tblDelLocPostals
I think I need an 'After Update' event procedure, on the postal code field (on frmAdresses), but I have no idea how to go about writing it. I just need the DelLoc 'NAME', to become visible to the inputter and, the delLocID to be written to tblAddresses... think I've said that twice..
Any guidance would be greatly appreciated.
Cheers,
Shannon