Using Access 2002. I have several tables, i.e, property info, buyer info, seller info, etc. The feature common to each table is one field with a unique numeric value, i.e., 50001211. I developed a form that when I go through each field, and key in the data, populates all of the necessary field in the tables. My problem is that when working in the form, I want to be able to use a drop down box (or something similar) to key in my identifying number. If I have already used that number, I want the number to show - and all the rest of the data fields for that record to appear. If I have not already entered that number and the associated info, I want to be able to enter a new record. Anyone have any suggestions on how I can accomplish this - and the associated code to use???
Grateful for any advice.
Bruce
Grateful for any advice.
Bruce