Creating a filter box for fields in a subform

D

DawnTreader

Hello

on my unbound mainform i would like to have a box that controls the query
that the subform is based on. is there a way through code to tell fields in
the subform to be filtered on what is typed in text boxes on the mainform?

do i need to place any special stuff in the query? i know how to create
parameter queries, but this would seem to be more complicated than that.

any help is appreciated! :)
 
K

kingston via AccessMonster.com

Lets say you have MainForm with control ComboBox. Create Query1 based on the
value Forms!MainForm!ComboBox. Create SubForm based on Query1 and when
ComboBox in MainForm is updated, invoke Me.SubForm.Requery. HTH
 
Top