Filter Sub Form

T

travis_5579

Hi ,

I have create a form call frmMain , in frmMain I insert
a subform name as 'Sub_Leave_Entry'.
Sub_Leave_Entry is set to Datasheet View and link to
one of the table.
I like to apply the
Me.Sub_Leave_Entry.Form.Filter = "ID='00001'"
Me.Sub_Leave_Entry.Form.FilterOn = True
but I failed to do it , please help me up.
 

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

Filter Sub Form 1
Requery main form after subform update and not lose place in main form. 3
Go to Control / Set Focus 1
Add a new record 3
Search Check Boxes on a Form Using Check boxes on a search Form 16
Change value in a table using VBA 4
Help creating a search form in Access XP 0
object or class does not support the set of events 0

Top