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