Hey guru's. I've been working with this form (S Contact Sheet)now for about two days . It's based off of a query (qryRepSiteVisits) with two tables(tblaAddresses and tblRepSiteVisits)in the query.
The form will be a data entry type of form that will assign a 'visit' (auto)number for each new entry, pulling info from the main Physician address table (tblAddresses), when the Reps enter the address number, I want the remaining address fields to autopopulate from tblAddresses and all this and the remaining visit information to be saved in tblRepSiteVisits.
Any assistance much appreciated.
The form will be a data entry type of form that will assign a 'visit' (auto)number for each new entry, pulling info from the main Physician address table (tblAddresses), when the Reps enter the address number, I want the remaining address fields to autopopulate from tblAddresses and all this and the remaining visit information to be saved in tblRepSiteVisits.
Any assistance much appreciated.