Edit and Add

[gguy]

I have a form that is bound to a query. The query pulls data from 2 tables. One table has company information including company number. The other table is the contact table (also has the company number field) which has contacts within the company. Editing and adding information to the contact table is the purpose of this form.

In the form I have a combo box that allows me to enter a company number and then I can page down through the contacts within that company.

I have data entry set to "no" in the form so I can see all records and page through them. The problem is that I can't add a new contact for an existing company. If I enter a new company in the company table it will appear in this form with blank fields but they will not allow entry.

Is this a settings problem or do I need a separate form to do the adds.

GGuy

 

[Jack Cowley]

Use a form/subform with the main form getting its data from the Customers table and the subform its data from the Contacts table. (I assume that these tables are properly related.) Now you can select a company in the main form and their contacts will be displayed in the subform where you can add more contacts or edit as you like.

hth,
Jack