I have a database that contains these 2 forms:
- Property: Purchase cost, HVAC info, insurance info, etc.
- Room_Dimensions: Room dimensions by property
They each have an unbound combo box with ID (hidden) and an address (visible) to select the property for which data should be shown. On the Property form there's a command button that will open the Room Dimensions form and display data for the selected property using OpenForm and the appropriate property ID in the where condition. That's all working properly but what I'd like is to have the combobox on Room Dimensions show the name of the property instead of being blank. I have the Property ID but don't know how to preselect that particular property in the combobox.
I suppose I could put the room dimensions info into a subform on the property form, but this info is rarely used and I'd just as soon it be separate.