L
LMB
Hi,
I have this exercise below working. Now I want to know if I can have my combo box on a form that has the record source set to another table and I want to select the names from my combo box multiple times to fill in fields on the form that will update my other table. I would be using the tblPersons as a lookup table and wanted the information when clicked on to automatically be entered into this other table.
example:
tblPersons is a lookup table with FName, LName, my combo box displays these names
tblAuditor is a table that has names of persons
I want to click on the combo box with the person's name and it insert the person's name in the FName field and LName field of the tblAuditor.
Thanks,
Linda
(Q) How do I have a textbox automatically fill in with a value after I select an item from a combo box on a form (e.g., select a person's ID in a combo box, and have the person's last name automatically display in a textbox)?
(A) The way to do this depends upon whether the textbox is bound to a field in the form's Record Source or not.
Unbound Textbox
In this example, we'll assume that your desired information is in a table named tblPersons, and that this table contains four fields: ID (the person's ID); FirstName (the person's first name); MiddleName (the person's middle name); and LastName (the person's last name).
Set the Row Source Type property of the combo box (assume it's named cboPersonID) to "Table/Query". Set the Row Source to a query that is based on tblPersons and that selects the ID and LastName fields:
' ***** Code Start *****
SELECT ID, LastName
FROM tblPersons
ORDER BY ID;
' ***** Code End *****Set the Bound Column property of cboPersonID to 1.
Set the Column Count property to 2.
Set the Column Widths property to this expression: 1";0".
Set the Control Source of a textbox (assume it's named txtPersonName) to this expression:
=[cboPersonID].[Column](1)
Note that the Column property of a combo box is "zero-based," meaning that the first column (field) in the combo box's Row Source is column 0, the second column is column 1, etc.
When you make a selection of a person's ID in the combo box, the textbox will automatically display the person's name. You can extend this example to include more textboxes by adding more fields to the combo box's Row Source query and setting the Control Source of each textbox to the appropriate column number of the combo box.
I have this exercise below working. Now I want to know if I can have my combo box on a form that has the record source set to another table and I want to select the names from my combo box multiple times to fill in fields on the form that will update my other table. I would be using the tblPersons as a lookup table and wanted the information when clicked on to automatically be entered into this other table.
example:
tblPersons is a lookup table with FName, LName, my combo box displays these names
tblAuditor is a table that has names of persons
I want to click on the combo box with the person's name and it insert the person's name in the FName field and LName field of the tblAuditor.
Thanks,
Linda
(Q) How do I have a textbox automatically fill in with a value after I select an item from a combo box on a form (e.g., select a person's ID in a combo box, and have the person's last name automatically display in a textbox)?
(A) The way to do this depends upon whether the textbox is bound to a field in the form's Record Source or not.
Unbound Textbox
In this example, we'll assume that your desired information is in a table named tblPersons, and that this table contains four fields: ID (the person's ID); FirstName (the person's first name); MiddleName (the person's middle name); and LastName (the person's last name).
Set the Row Source Type property of the combo box (assume it's named cboPersonID) to "Table/Query". Set the Row Source to a query that is based on tblPersons and that selects the ID and LastName fields:
' ***** Code Start *****
SELECT ID, LastName
FROM tblPersons
ORDER BY ID;
' ***** Code End *****Set the Bound Column property of cboPersonID to 1.
Set the Column Count property to 2.
Set the Column Widths property to this expression: 1";0".
Set the Control Source of a textbox (assume it's named txtPersonName) to this expression:
=[cboPersonID].[Column](1)
Note that the Column property of a combo box is "zero-based," meaning that the first column (field) in the combo box's Row Source is column 0, the second column is column 1, etc.
When you make a selection of a person's ID in the combo box, the textbox will automatically display the person's name. You can extend this example to include more textboxes by adding more fields to the combo box's Row Source query and setting the Control Source of each textbox to the appropriate column number of the combo box.