I would like to put a combo box on a form that is connected to a table. I would like to put a text box that is populated with a field from the same table, but would get a reference to the current record from the combo box control. Can this be done?
Novice
Windows 7 64bit 
Access 2010 32bit
I would like to put a combo box on a form that is connected to a table. I would like to put a text box that is populated with a field from the same table, but would get a reference to the current record from the combo box control. Can this be done?
Administrator
Windows 7 64bit Access 2010 32bit
Have you tried using the ComboBox wizard for this yet?
Novice
Windows 7 64bit Access 2010 32bit
The problem is linking a Text Box to a field in the same table BUT syncs with the current record selected in the Combo Box. I know it is a setting in the properties, but cannot figure out what it is. Thank you for responding tho.
Administrator
Windows 7 64bit Access 2010 32bit
Your form needs to be bound to a query that joins the two tables then.
Novice
Windows 7 64bit Access 2010 32bit
The information to be displayed in the Text Box is in a field in the same table as the Combo Box.
Administrator
Windows 7 64bit Access 2010 32bit
You should be able to join those two tables. Don't you have a relationship defined for these two tables?
Variable within form control reference
Posting Permissions
Reply With Quote