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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moche - 30 Jan 2005 02:55 GMT

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.

Reply to this Message

Van T. Dinh - 30 Jan 2005 03:17 GMT

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)

Signature

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.

Reply to this Message