Sub form filtering or query

[ABolton]

I have an aplpication where i want to narrow down the records shown in a sub form by chossing values in the main form from list or combo boxes.Probably need three or four of these boxes, which as chossen would reduce the number of records in the sub form. Have tried using the on clck to run a filter but doesnt seem to work for more than one box.

I can design the form up to look right but cant link it all togerhter. I probably need to find an example somehwere to look at and copy. All the data is currently stored on a single main table, altough the fields of the main table that i am trying to use to make the selection in the list boxes are also set up as queies and sepearte tables. Any help on where to look is appraciated. Once the list in the sub fomr has been narroweed down, then there is a hyperlink to open a document, but that part i have sorted out already.

can anyone suggest anywhere to look for details or an example that i can access on line. I do have some screen dumps of what am trying to do if it would help anyone to help me.

regards

ady

 

[JimYellow]

Use the master child links in the subform propertys

set child = box1; list1; box2; list2
set master = field1; field2; field3; field4

try it with one combo or list then add the others in turn

if you are setting these from code first set them to ""

 

[ABolton]

sorry for being dumb.
On the sub form i set child to

"child = list0:"

where list0 is the name of the list box on the main form and set

"master = product manufactuer;"

where product manufacteuer is the name of the field in the sub form.

this then links the choice in the combi/list box to the recorsd sthat show the same selcection in the sib form for the feild prodcut manufactuer?

regrads