user data input - text box question

[unit213]

This should be an easy question since I'm relatively new to using forms...

I have two text boxes on a form. A user will enter a quantity into Textbox1
and the same user will enter a date into Textbox 2. I'll then append
the data to a table. Assuming the pic below represents my form, I would like to be
able to enter different dates and quantities based on part number.

I have the form built. However, when I enter a value (number or date) into either
text box, that value applies to all textboxes like in the example below. It's as if each text
box is pulling the data from the first text box where I've entered the data.

Any suggestions on how to make the date & quantity text boxes independent and apply to a single part number only?

Thanks in advance for any help you can offer.

 

[SydneyGeek]

This comes down to bound and unbound controls.
A bound control is connected to a specific field (such as OrderQty or OrderDate). When you change a continuous form you will change the textbox for that record only.
An unbound control doesn't have anything in the ControlSource property. When you edit a control like this, every record on the form gets the same value.

Denis