show all records

[Karen]

Hi,

I have a form that has several combo boxes. Each time the user selects
something from a combo box, queries are run and a record set returned to
match the specified criteria. (i.e. the form opens with 200 records, but by
using the combo boxes the user can get down to 1 record. ). Without closing
and re-opening the form, how can I get the form to display all of the records
again? I tried ShowAllRecords, but didn't have any luck. Any suggestions
are appreciated.

 

[Steve Schapel]

Karen,

Without knowing the details of what you've got there, I guess you could
remove the selections from the comboboxes, and then requery the form.
Removing the selections could be done by manually deleting them, or you
could put a command button on the form, and use a macro or VBA procedure
to clear the comboboxes.

 

[Karen]

Thanks, that worked perfectly. I used a macro and setvalue to set the value
of my combo boxes to null and then did a requery on the form

 

[Steve Schapel]

Brilliant.