cant add data

[Guest]

ok here goes.

I have an invoice form that displays customers details and a subform that i
use to enter products for customers(obviously)

the problem is that i can only add one line on my subform.

I have an order details table with the following fields:-

orderNo - Autonumber
customerid
partNo

when i enter a part no it tabs to the quantity text box and after i enter a
quantity it returns to the previous text box but i want it to go to the next
line(record(I Think))

any ideas

 

[ManningFan]

Is your relationship set up to be a one-to-many? Also, check the
properties of your text boxes, make sure their "Enter Key Behavior" is
set to Default.

 

[Guest]

The relationship was wrong thanks for the pointer.

The next problem is i use dlookup to autofill the description but when i
enter a part into the second line the description changes on every line.

 

[ManningFan]

Is this a single form or a continuous form?

The relationship was wrong thanks for the pointer.

The next problem is i use dlookup to autofill the description but when i
enter a part into the second line the description changes on every line.

 

[Guest]

it is a continuous form

Is this a single form or a continuous form?