Please help

[kdcooper88]

I have created a form to allow customers to register at an open house at work. However I am trying to figure out a way to automatically fill certain fields if two customers from the same company come and one has already registered. For example; if john smith from company xyz came to register and bob brown from the same company had already registered, once john smith entered in xyz in the company name field it would automatically fill in the company's address, city, street, zip code, phone number, and fax number based on the information bob brown gave when he registered. Is it possible to do this without having a company list already created for it to reference? Please help and let me know if this is not clear.
Thanks,
Kyle

[NTC]

Provide them a combobox to select from. Set it to source from the registration table. You will probably need to tweak that combobox's underlying query source to be 'Unique' - otherwise you will get repeat lines of the same company wherever there are multiple registrants.

Once selected - in 'AfterUpdate' you can then autopopulate the records' fields from the comboboxes' fields.

Hope this helps.