Filter Records Code Needed

D

Dave Elliott

I need a filter for my form TimeCards that has a sub-form on it named
FTimeBillingSub with a control on it named BillPer
If BillPer IsNull, then show all TimeCards
Tried the below code, it did not work.

DoCmd.ApplyFilter "", IsNull("Forms!FTimeBillingSub!BillPer")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statement Help Needed 7
Date Difference from Now on sub-form 1
Visible or Invisible Question 17
Date Difference Help Needed 5
Make Label Visible or Invisible 2
If Statement for Sub-Form 7
If Statement Referencing Sub-Forms 6
Code on Current Event of Sub-Form 9

Top