Add new record from a form

[seducedbycodes]

Hi,
Trying to add new records (containing differing info) to two separate tables from one form containing text boxes and a datasheet. Was trying to implement this using SQL INSERT INTO within VB code, but cannot get it to work.
This is for an invoice, i want to send all of the customer details to the invoice table and all of the part and quantity to the parts quoted table.
Any help would be greatly appreaciated
cheers

 

[dcurtis]

Why not use a form/subform setup? This way Access will do most of the work for you. Check out the Northwind sample that ships w/Access.

 

[seducedbycodes]

Thankyou for your suggestion and i tried this option but ran into a difficulty...
I'm having trouble entering data into the subform in datasheet view. As soon as i change this forms data entry property to yes the subform becomes empty and there are no rows to enter or change any existing data.? What i want
is for the form and subform only to open and display empty fields for data input.
cheers
beck