I have a combo box on my form. The list currently is populated by the PROPERTYNAME from the PROPERTY table. I would like to set the combo box up so that as you navigate through the NUMBERS table, the combo box will display the PROPERTYNAME of the corresponding NUMBERS record while still providing the option to select a different PROPERTYNAME if needed. The two tables are linked by the PROPERTYCODE field. How can I achieve this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I am having Combo Box problems?
- Thread starter ZPlay
- Start date
67peshawar294
Technical User
2play Hello,
If your info is in one table add the name of the field to the rowsource selectdistinctrow, increase your column count and enter widths for the number of colums separated by commas.
Jim
If your info is in one table add the name of the field to the rowsource selectdistinctrow, increase your column count and enter widths for the number of colums separated by commas.
Jim
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
