Multiple Form Entries...

[DasT]

In my db i currently have 2 tables, one for company information, and one for other contacts, the other contacts table has a One company to many contacts link, thus there will be one company and then as many contacts as needed stored per company.

What i need now if a method to input and display these contacts via a form, is it possible to switch between contact records in a single txt box or through another method?

thanks for your help

 

[Norie]

Create two forms.

A company form based on the company table with companyID, name etc.

A contacts form based on the contacts table with companyID, contactID, name etc.

Save these. Open the company form in design view, ensure that the Toolbox wizard is on. Now add a subform.

Access should guide you through the process of addding the contacts form and linking it (via company ID) to the company table.

 

[DasT]

Ah now i see, thanks it works great, but it there any way to make this blend in with the rest of the form? rather than it looking so seperate? if you get my meaning

 

[Norie]

if you get my meaning

No I don't.

You can change the properties of the subform itself and also the subform control on the main form.

BTW the best way to view multiple entries like you have would be to set the Default View property to Continuos Form.