Hi,
I'm trying to create a form which allow me to type some data in and filter it down, however I've never really worked with forms before, so I'm not sure how to link it with the data. Here is a screenshot mockup of what I'd like to do:
http:// i.imgur.com/ONouM7X.jpg
The 3 "style code" boxes are the season/STY_NUM/STY_QUAL fields, and the colour and fit are, well, the colour and fit fields.
It doesn't need to be all fields filled in to bring up the results, i.e. if I just type in "AAA" to the first box and leave the rest blank, I'd still like it to only filter down to any rows with AAA in the season box, and likewise if I fill in all of the fields with specific data, then filter down to that specific combination.
Also I don't know if it matters or not, but the spreadsheet is refreshable and the amount of rows will change, so it would need to work with the entire spreadsheet really.
I've managed to get the button to call the form correctly and the cancel button works, which isn't much, but connecting the input boxes with the corresponding columns I don't have a clue how to proceed![]()
Bookmarks