Property Sheet - data question

[hafiff]

I made a form that will pull the name from the list of a table as the Row Source on Data tab of the Property Sheet. I would like to have the option to select all name. I entered on Default Value as "*", but it will not show. Is there away to show on the form instead of blank for all.

I am not sure on how to insert the image of the sample. Any simple instruction will also help.

Thanks,
HA

 

[ranman256]

If you are going to use ALL names, then use a different query than the one that pulls 1 name.
qs1Name and qsAllNames

If you want all names, join the table of names to the query and it will pull all names. The form is irrelevant.

 

[hafiff]

Thanks!

 

[HiTechCoach]

I made a form that will pull the name from the list of a table as the Row Source on Data tab of the Property Sheet. I would like to have the option to select all name. I entered on Default Value as "*", but it will not show. Is there away to show on the form instead of blank for all.

I am not sure on how to insert the image of the sample. Any simple instruction will also help.

Thanks,
HA

WARNING: Using the Row Source on the Data tab of the Property Sheet can cause you many headaches.

I NEVER USE THEM!

SEE:

The Access Web - The Evils of Lookup Fields in Tables

​