T
TeeSee
I have a single form supplied by a query based on an underlying table.
All I want to do is have someone input a lot of data and I'm trying to
make it as simple as possible. There are three fields to input.
The first field I made unbound, the next two I are bound to the table
thru the query. In the first field the data will be a part number eg
ACSMSEP1604. The alpha part will be common to all records so I
intended to have the user input the numerical part of the number only.
There is a fourth unbound control on the form with the control source
of ="ACSMSEP " & [ctlItemCode] which gives me the entire code. How do
I get that value into the field in my table named txtSISitemCode at
the same time that the bound controls update the table?
Or is there a better way to do this? Thanks again
All I want to do is have someone input a lot of data and I'm trying to
make it as simple as possible. There are three fields to input.
The first field I made unbound, the next two I are bound to the table
thru the query. In the first field the data will be a part number eg
ACSMSEP1604. The alpha part will be common to all records so I
intended to have the user input the numerical part of the number only.
There is a fourth unbound control on the form with the control source
of ="ACSMSEP " & [ctlItemCode] which gives me the entire code. How do
I get that value into the field in my table named txtSISitemCode at
the same time that the bound controls update the table?
Or is there a better way to do this? Thanks again