G
Gazza
when i open the main form i enter a customer id which autofills the customer
details at the top of the form and sets the discount for all items entered on
the subform and sets focus on a part no text box on the main form.
I then enter a part no into the part no text box on the main form and it
passes the value to the subform and displays the data required for that part
no.
After entering the part no and pressing enter it then sets focus on the
quantity text box but when i enter a quantity and press enter it then sets
focus back to the part no text box which i want it to do but it clears the
data from the subform because the master/child link is the part no and i have
set the part no and quantity boxes to = NULL when they have focus.
The subform is set as a continuous form so i just need it to goto the next
line in the subform after i have entered the quantity so i can enter another
part no.
Please help as it is seriously stressing me out.
details at the top of the form and sets the discount for all items entered on
the subform and sets focus on a part no text box on the main form.
I then enter a part no into the part no text box on the main form and it
passes the value to the subform and displays the data required for that part
no.
After entering the part no and pressing enter it then sets focus on the
quantity text box but when i enter a quantity and press enter it then sets
focus back to the part no text box which i want it to do but it clears the
data from the subform because the master/child link is the part no and i have
set the part no and quantity boxes to = NULL when they have focus.
The subform is set as a continuous form so i just need it to goto the next
line in the subform after i have entered the quantity so i can enter another
part no.
Please help as it is seriously stressing me out.