How do I select a particular combobox item to appear in a form being opened from another form?

[samsquared]

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.

[June7]

Try in Room_Dimensions Open or Load or Current event.

Me.comboxname = Me!PropertyID

[CJ_London]

Assuming the combo box returns 2 fields properttyPk and property name in that order, set the column count to 2, bound column to 1, and column widths to 0 and the control source to the name of your propertyFk

[Micron]

Why not use a subform for dimensions? Then the property details are visible above the subform and you don't have to get them into a separate form.

[June7]

CJ, OP said control is UNBOUND and purpose is to select property to filter form. Controls used to select/enter filter criteria should not be BOUND.

[samsquared]

June7, thank you for the quick reply, - that did it! I guess I thought it was going to be more involved, so doing that did not occur to me.

Thanks to all who tried to help.