Main Form/Sub-Form Issues

[smbarney]

I have a main form (fmnMain) with a one to many sub form(sbfmnContactInfor). The main form is office buildings and the sub form displays contact inform for each location

On the subform, I have an unbound list box that lists the current entries for that location. I would like to be able to double click a name and have it jump to that record.

I have done this before using a macro and open form command setting the where statement to the equal the ID. However, this does not work, at least I cannot get it to work, with a subform.

Any thoughts on this? Thanks.

 

[llkhoutx]

I'm not sure whether the name you want to double-click is on the main or sub form.

I do assume that you have appropriately set the the Link Master Field and Link Child Field properties of the subform correctly and that the subform tubles, displaying multiople subform records for the linked fields.

If what you want to do is advance to a particular subform record, after many have been return, merely set the subform FilterOn property to True and the subform filter property to the filter value which will return the requisite value, then requery the subform to display that record.

The FilterOn property must be set to False on some event to display all children of the manin form record.

 

[smbarney]

Thanks...Got it.