Search results

I use [Forms]![MyForm]![MyCombobox] for each criteria that refers to a combo box on MyForm

I tries that and it still doesn't allow you to filter by one combobox or multiple comboboxes on the same form for a single listbox

Do you do this for one field, as putt all the criteria into seperate lines in a single field, or put the criteria into the criteria line under the field that the combo box refers.

Following on from this, how do you put multiple criteria in the SQL without the filter criteria conflicting. I have tried putting criteria linked to mulitple Comboboxes, but they either all have to have data or it just doesn't work. I need them to work independantly if a single filter is...

I think the word Name is reserved in Access for other uses os I think this may be where your problem lies. And possibly you need to tell it that your information is in character format ie & chr(32)

IS there a link or can anyone give me a few pointers on how to set up a Date to From filter on my form that is linked to a List Box. Just wondering if there is an easy way, plz:rolleyes:

I wanted to do a similar thing so I created a Combo box that i could select, in your case the sport, from. Use the row resource and do a list of the intended sports. Now create a list box and filter using the data in the combo box from your table (which should contain 2 fields ie Sport, Team...

I have a command that give me a runtime error if someone could help me with that: DoCmd.OpenForm"MyForm', , , "[MyFilter]=" & Mylistbox Can anyone see the syntax here???

How do i get a List box to open a form with the details of the item I double clicked in the List box?? At the moment it just opens the form with the first record and not the record i selected.

Got it sorted...just had to add a requery to the code. mylistbox.requery Simple huh :(

How do i get a List box to requery/refresh when i select a new filter in a Combo box. And is it possible ( I know anything is possible ) to have multiple combo boxes to filter a list box without conflicts, as in if i select the first constraint in the first combo box and then select a second in...