Allowing Autofill on a field

[LukeJ Innov]

Hello All,



Right this could be hard to explain but here goes, I have a form with a sub form (see:attached), it shows data on a customer, then data on that customers contacts in the sub form.

Now both forms are linked on their respective tables by the 'Customer_ID' field, however on this form I would like the 'Customer_ID' field to be automatically filled when either a existing customer is selected, or a new one is created.

Ideas?

Thankful Regards,

LukeJ

P.S. I know the form is messy


I have figured it out for my self, what you must do is go on the main forms property sheet, select the sub form, do to its settings and set up the link between master and child.
Pretty straight forward.