Sub form filter or query

  • Thread starter Thread starter adybolton
  • Start date Start date
A

adybolton

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
 
Back
Top