Search results

Thanks for your prompt and logical solution. Using the subform allows me to eliminate the duplication of fields between my two tables. I have been trying to use the controlsource box in the properties to make the input from the user update two separate fields at once.

My database aims at holding details about clients enquiring to our company. I have a form named 'Enquiry' which lets the user add an enquiry record in my 'Enquiry' table. I have a field in my form which takes in the company name. What I want to do is automatically create a record for more...