Finding a specific record on a subform

[BMag]

I have a database that is similar to the Access supplied sample address database. I am attempting to modify it to suit my needs.

I have two tables, Household - primarykey householdID, and Members - primarykey memberID. They have a one to many relationship on the field named HouseholdId in both tables.

I have a main form, "Household", with three tabs (pages) on it. On the 2nd page is a subform "members". "Household" is linked to "members" by household.householdID=members.householdID

On another form - "Select"- I have a combo box - (cboSelect) - that is populated with a list of names and memberID's - (memberID,Firstname).

What I am trying to do, with out much luck so far, is to choose a name from "cboSelect", then click a button- "Go" which will open the form "household", goto the 2nd page and from the "members" subform goto the record associated with the memberID from "cboSelect"

I have it working up through opening up to the second page of the houeshold form on but it will only go to the first record on the members form. The record is there, I can step to it with the mouse or the record selector. I can not get it select the correct record based on cboselect memberId.

Any suggestions would be greatly apreaciated. I've included alot of detail but I wanted to give a complete picture of the objects in question.

 

[aleb]

Try this example:

 

[smercer]

You want to use a query with the criteria based on the combo box. the subform would be based on the query. see attachment for help on this.