Pick List Page

M

Mick

Thanks to Kathleen I have created a pick list page for records from the
Access database, which selects from a specific field. How do I add an option
that will after having selected a particular choice, take me back to the full
list of records for perhaps another selection. I think i am saying is there a
wildcard selection facility that will list all options again, i.e. take me
back to the original list.
 
S

Stefan B Rusynko

Depends on your Pick list set up
A search string of % as a wildcard will show all records




| Thanks to Kathleen I have created a pick list page for records from the
| Access database, which selects from a specific field. How do I add an option
| that will after having selected a particular choice, take me back to the full
| list of records for perhaps another selection. I think i am saying is there a
| wildcard selection facility that will list all options again, i.e. take me
| back to the original list.
 
M

Mick

Thanks to Stefan and Kathleen.
If I click the database results box in the Pick list page, I can see in the
drop down box properties the DBRW results code. If I add another option "All"
and in the value field place the % no results, however if I type in a
specific result I know is in the list it produces the results.
Is there a wildcard like the % that I could be putting in the "value"
column, or more likely am I attempting the impossible. I really just wanted
to try to include the "All" option in the drop down list produced from
Kathleens "Pick List" tutorial ( Very good incidentally).
Thanks
Mick
 
Top