In Access 97, I have a report that prints based on the field selected from a combo box form. The report uses a query as the recordsource, where the field Criteria in the query =forms!frmForm1!cmbfield1 . This works great, but I'm trying to get the combo box to offer up "(All)" and then use that value in my query. I used the example by Dev Ashish, but am still having trouble getting this to work.
Can someone help?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.