How do I add an "*" as the default choose of a custom form that c.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a custom form that collects parameters that are passed to a
query thats the record source of a report. I want to add an asterick as the
default choose so that all records are returned unless another choose is made.
 
It may be easier to simply use the correct criteria in the RecordSource for
the Report. Form example, if you want to select Records where Field1 =
TextBox1 but select all Records when TextBox1 is empty, you can set the
criteria (in the RecordSource of the Report) to

.... WHERE (Field1 = Forms!YourForm!TestBox1)
OR (Forms!YourForm!TestBox1 Is Null)

--
HTH
Van T. Dinh
MVP (Access)


Moche said:
I have created a custom form that collects parameters that are passed to a
query thats the record source of a report. I want to add an asterick as the
default choose so that all records are returned unless another choose is
Click to expand...
made.
 
Back
Top