Select all records from a select query criteria question box

[Mithrindal]

Is there a syntax which would allow the selection of all records from a selection query criteria box. I.E when query is ran, 2 inputs are required 1 is [Group Name ?] and the other is [Model Name ?]. Is there a way of selecting all records for one or both of these prompts? I have tried leaving the prompt blank, using an "*" etc with no luck.
Seem to remember somewhere in the dim dark depths of tek-tips that there was a solution, but I could not find it.

Does anyone out there know or remember the solution, if so you're help would be appreciated.

Cheers

Hugh

 

[hermanlaksko]

Perhaps a select statement could be the trick i.e.:

Select Case GMName
Case = "Group"
MySQL= "Select * From MyTbl Where Group=" & my!ctl
Case = "Model"
MySQL= "Select * From MyTbl Where Model=" & my!ctl2
Case="GroupModel"
MySQL= "Select * From MyTbl Where Group=" & my!ctl & " And Model=" & my!ctl2
end select

There are other solutions to this problem but this could be one.