Hot set current record on subform from main form's code

[MattLewis]

How do I set the current record of a sub-form from the main form's VBA code?



Here is where I'm at (and since I'm new to Access, this could be down the wrong pat)

1. Main form has a listbox
2. Main form has a subform
3. I want the subform to select a record based on the list box current selection

4. subform has a public subroutine that selects a record based a given parameter
5. After update event on listbox calls that subroutine, passing it the proper parameter
6. The subroutine on the subform is being called when expected, but the subform isn't refreshing to the show the newly selected record.

[ranman256]

dont use a subform, use a master form, use a combo, then you just....

sub cboBox_afterupdate
   me.filter = "[field]='"  & cboBox & "'"
   me.filterOn = true
end sub

but if you must use a subform, make 2 queries, 1 for all records, 1 that looks at the list box to filter records

sub lstBox_afterupdate
  if isNull(lstBox)then 
   me.subform.rowsource = "qsAllRecords
 else
   me.subform.rowsource = "qsFilterByListbox
 endif 
end sub