B
Billy Smith
In an Access 2000 application, I have a table of records and I want to
create a
form that is bound to a query of that table such that the user can edit the
records.
Specifically, one field is EmployeeID, a numeric field.
I want the user to be able to change the employee ID in the record only by
selecting the employee name from a combobox. I can easily get the employee
names and IDs from a table and put them into a combobox.
If I were to let the user change the EmployeeID via a text box it would be
easy
to bind the text box to the EmployeeID field. But using a combo box with
names
linked to employee IDs is indirect. Giving the EmployeeID field in the
table a
lookup control is not an option because I'm afraid that would mess up the
many other
queries and forms that currently use the field as it is.
I know how to use an invisible bound column in a combobox so I know I can
get the ID
when the user selects an employee in the combobox. But how can I link the
ID value to
the database table so the value gets changed in the record?
I'm fluent in VBA for Access. Thanks in advance.
create a
form that is bound to a query of that table such that the user can edit the
records.
Specifically, one field is EmployeeID, a numeric field.
I want the user to be able to change the employee ID in the record only by
selecting the employee name from a combobox. I can easily get the employee
names and IDs from a table and put them into a combobox.
If I were to let the user change the EmployeeID via a text box it would be
easy
to bind the text box to the EmployeeID field. But using a combo box with
names
linked to employee IDs is indirect. Giving the EmployeeID field in the
table a
lookup control is not an option because I'm afraid that would mess up the
many other
queries and forms that currently use the field as it is.
I know how to use an invisible bound column in a combobox so I know I can
get the ID
when the user selects an employee in the combobox. But how can I link the
ID value to
the database table so the value gets changed in the record?
I'm fluent in VBA for Access. Thanks in advance.