Unbound text box repeating value.

J

Jason V

I have an unbound text box in the detail section of a tabular form. I enter
a value in this text box and VBA Code returns values for several bound text
boxes for that record.
When I move to the next record the unbound value (from the first
record)automatically fills in the unbound text box for the next record.
When I edit this value (in the second record) it also edits the value in the
unbound text boxes previous.

Hope this makes sense. Let me know if I need to be more clear.

Thanks
Jason V.
 
O

Ofer

An unbound field in a continus form will always repeat it self in all the
records, you need to bounf the field to a field in the table.
What is the point of putting different values in diferent records if you are
not saving them? what is the purpose of the this field?
 
J

Jason V

The form is to "reverse" transactions from previous entries (employee hours
charged to specific contract numbers, etc.). The unbound field is the unique
reference number of the "transaction I need to reverse". When I enter the
number the rest of the fields on the form for that record are populated with
the data from the initial transaction (excluding the hours worked, which is
changed to a negative) and the transaction is issued a new transaction number.

The user just has to take a list of transactions that need to be reversed
and enter them and the rest is automated. I don't want to store the original
reference number again.

Thanks
Jason
 
O

Ofer

In that case I would suggest creating another field in the table and to bound
the field in the form, mybe you can also used it for future reference where
you got the values for the other fields.
Or create a single form instead of a continues form.
 
J

Jason V

OK......Thanks, atleast now I know my limitations. I will pursue this from a
different angle.

Jason
 
Top