Check and create new records in to joined tables from a form with

Hope I understand your question.
Yop make  two tables one with the HeadTab and one with the DetailTab. Then you should be bale to use the form wizard to create a form containing a sub form. The main form should display information on HeadTab and the subform information on DetailTab.
No you shoulkd NOT need to use VB

Yop  = You

In the form wizard you choose which tables you want to use in the form and Access will see that there are two related tables. Follow the instructions and see how it goes. It should be quite easy if they are related.

I used the wizard and made the form with the subform.
Do I have to make a query based on the form? Because first I have to check the HeadTab for records with the same data. If I find a record in the HeadTab, I use this record. Then I only make a new record in the DetailTab and link this to the already existing record in the HeadTable
Øyvind

Not quite sure what you are trying to do?
Records in the HeadTab table should be unique so there should only be one!

If the wizard has made your form with a subform then you can enter a new record in the main form and then add related records in the sub form.

An example: In an Order you will have an order header (unique) which contains information about the customer, infromation wich exists only once. Then normally at least one detail record containing information on each item purchased.

So when you create the order you enter the main order infromation in the header and then each item purchased in the sub form. If at a later date you look at this order again then you will see the related (detail) records.

The value of the HeadTabID is unique for every record.
But I also want that the combination of the other fields should be unique. For instance: there are 2 other field in the table.
In one record field 1 have value "a" and field 2 have value "b"
If I type "a" in field 1 and "b" in field 2 in the form, "The form should make a new record in the DetailTab" and link this record to the already existing record in the HeadTab.
Sorry I'm so bad to explain

are you saying that more than one field is used in your primary key for HeadTabID? If this is correct then You also need all three fields as the foreign key in your DetailTab.

To make a primary key from thre fields you open the table in design view. Then holding the Ctrl down select the three field and then press on the key icon on the menu. Then you need to alter the design of DetailTab so that the foreign key contains all three fields. NOW I suggest you delete the forms and use the wizard again to create them. Access should see that there are three fields in the primary and now when you create records in HeadTabID and DetailTab they will be releated on ALL THREE fields

Thanks Terry,  I'll try. If I can't make it. I have to ask again later. Øyvind

OK. I think you should also concider buying a book on Access, this will save you much frustration.

thanks for the points.