D
D.J.
First and most important I am very new to Access (first project)
I am using access 2k I have created a frm based on a multiple tbl qry
all are bound. On the frm I have 6 fields 5 of which are making the
6 th using the control source to concatenate the others together into
a 14 char text sting I want this to update the primary key for the
table. The 14 char string creates a unique text string that will
relate to only one map. I,m not trying to set the primary key from the
form just get the info from the form to update the field in the table.
I have a table with a field that matches each field in the form. The
other fields in the table update as I input data into the form. The
problem is the one I create when I put the others together. The only
thing different is that I use the control source in this text box (on
the form) to get the information from the other five. If I get rid of
the control source code I've put in it works. What I've done is put
the line =[a] & ..etc ( for the control source for [f] ) to get [f]
to read those fields concatenated together on the form. I see the
result on the form but it is not updating the related field on the
table.When I finish entering the data in the form and press the save
button I'm getting a message that says primary key can not be nul.
The table is not updating with what I am seeing on the screen. Is
this update something I need to do with an after_update exp or the
like. If so how please. You may ask why not just enter the 14 char
string and be done with it. The answer is those people entering the
data (big finger effect)
I am using access 2k I have created a frm based on a multiple tbl qry
all are bound. On the frm I have 6 fields 5 of which are making the
6 th using the control source to concatenate the others together into
a 14 char text sting I want this to update the primary key for the
table. The 14 char string creates a unique text string that will
relate to only one map. I,m not trying to set the primary key from the
form just get the info from the form to update the field in the table.
I have a table with a field that matches each field in the form. The
other fields in the table update as I input data into the form. The
problem is the one I create when I put the others together. The only
thing different is that I use the control source in this text box (on
the form) to get the information from the other five. If I get rid of
the control source code I've put in it works. What I've done is put
the line =[a] & ..etc ( for the control source for [f] ) to get [f]
to read those fields concatenated together on the form. I see the
result on the form but it is not updating the related field on the
table.When I finish entering the data in the form and press the save
button I'm getting a message that says primary key can not be nul.
The table is not updating with what I am seeing on the screen. Is
this update something I need to do with an after_update exp or the
like. If so how please. You may ask why not just enter the 14 char
string and be done with it. The answer is those people entering the
data (big finger effect)