How to go to record in bound form

[ittechguy]

I have a specific example here but I have 3 other forms that could benefit from figuring this out.



I've got a form here which I used to make changes to information associated with Equipment. Such as building/room/cabinet and logical information such as hostname, IP address, etc.



The physical location and the physical equipment information text boxes are locked text boxes, used to display information. If I click on a record in a subform, it will open up this form and go to the correct record and thus, display the correct information. I.E., if the subform is displaying all information for EquipmentPK 1, that record will open up in this popup form.

I'm trying to create a way to go to a record on this form without having to exit out of the form and click on a different record in the subform. I would prefer if I had unbound combo boxes possibly in the header of this form. How exactly is that done?

[June7]

Review http://www.allenbrowne.com/ser-62.html

[ittechguy]

Thanks for the link.

I had thought I might need to create a search form. I have reviewed that previously, and I have several search forms in my database.

I hadn't thought much to use Form.Filter here because I wasn't sure how to handle if the filtered form shows more than 1 results.

[June7]

What's wrong with more than 1 result?

[ittechguy]

More I think about it, I guess nothing.

If you notice the form I posted above, record selectors are hidden I might unhide them if that makes more sense. However being a form which is bound to a rather large query, there are numerous records. I just want the correct equipment to be displayed. Thanks for the help.

[June7]

Record selector really means nothing on this form. Unhide the record navigation bar if you want users to be aware that multiple records met the criteria.

[ittechguy]

A search form did the trick. Thanks for the help!