cant add data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
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.
Click to expand...
 
Back
Top