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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make combo box in my form control subform

Status
Not open for further replies.

chasmith17

Technical User
Joined
May 25, 2006
Messages
47
Location
US
Hello,
I have a combo box in my form that has asset ID's. When I select the asset ID it comes up with a few fields describing the asset. Then I have a subform with that has repair info. like problem, repair description, status of repair, and time spent. Here's what I am trying to do... When I select the asset ID in my form I want it to link or be specific to the subform record so I can go back later and find the service records for the asset ID. I hope this makes sense, if not I can try to explain further. Thanks,
 
If your Main form is not bound then you can just link to the value in the combo. So if the combo is "cmboAssetID". Your subform links could be.

master: cmboAssetID
child: assetID

If it is bound then just link to the field in the master.
 
Sorry for the silly post, I was not thinking on this Monday morning. I forgot an important step....MY relationship.
 
It may not be that silly. Ofter people only think you can link subforms from field to field in the recordsets. But you can link to a control which is useful in making synched subforms.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top