blank combo boxes used for form selection (1 Viewer)

[stretch66]

Hi All,

Am using a number of combo boxes as selection criteria for a report. The combo boxes are linked to a table, obviously there will be times when no criteria is required and will want to select "ALL" when left blank.

Is there a simple solution ?

Cheers

 

[Rod D]

Hi Stretch

Look in Martin Green's examples -
http://www.fontstuff.com/access/acctut19.htm

Does everything you ask for...........and more!

Hope this helps
Regards
Rod

 

[stretch66]

Thanks Rod................sorry for taking so long to get back but had another database to put together.

Will take a look.