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

[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.

 

[Van T. Dinh]

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)

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.