P
p-rat
I have a form where I have a combo box that is a lookup from a table
where there are only two fields 'location' and 'locationID'. It looks
up the 'location'. If the location isn't in the table the user has the
ability to add this to the table or list (a form will appear with two
text boxes 'location' and 'locationID' for the new values. It will
then ask if you want this value added to the list. All works fine.
My problem is that I then have a autofill field after this that shows
the LocationID (after update event of combobox):
Me.LocationID.Value = Me.Location.Column(1)
When I tab out of the combo box and expect the Location ID to autofill
into the next field there appears an error box:
run time error '2113'
the value you entered isn't valid for this field
I have no clue to what is taking place. If anyone could point me in
the right direction it would be great. Thanks.
where there are only two fields 'location' and 'locationID'. It looks
up the 'location'. If the location isn't in the table the user has the
ability to add this to the table or list (a form will appear with two
text boxes 'location' and 'locationID' for the new values. It will
then ask if you want this value added to the list. All works fine.
My problem is that I then have a autofill field after this that shows
the LocationID (after update event of combobox):
Me.LocationID.Value = Me.Location.Column(1)
When I tab out of the combo box and expect the Location ID to autofill
into the next field there appears an error box:
run time error '2113'
the value you entered isn't valid for this field
I have no clue to what is taking place. If anyone could point me in
the right direction it would be great. Thanks.