new line in subform

G

Gazza

Is there a way to get a new line to appear in a subform.
in my subform i have a line of textboxes that display the data from a
table(product details).on my main form i have a text box that i enter a part
no into and when i press enter it displays the part no and associated details
in my subform and moves the cursor to the quantity box which works ok but my
problem is that once i enter a quantity and press enter the cursur returns
to the part no box on my main form which i want but it also clears the
details in my subform which i dont want.
i would like to know if you can get a new line to appear on the subform
after pressing enter in the quantity box of my main form.

please help
 
G

Gazza

ok i got the new line sorted by using continuous forms in my subform but
because the link between the main for and sub form is the part no text box
when i enter a part no it enters it into the first line then goes to the
second line which also displayes the part no i typed which isnt quite what i
want. i want it to enter the part no and details into the first line then
when i enter a quantity it will enter it into the line and then goto the part
no box so i can enter another part no that will then be displayed in the
second line.

thanks in advance
 
Top