Filter by Form Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a database using Access 2003. There is no security in it as
there are only four of us using it. Never thought there was a need.
My issue is this, when we do a filter by form in tab 1 and then go across to
tab 3, all the information has disappeared. Yet if I go into design view and
then back, the info appears.
How can I rectify this?
 
I think you need to requery the data on the other tab controls.

Forms!FormName!SubFormName.Requery

I usually put this in the Form_Current event.

Crystal
 
Thanx for the reply but that went right over my head. Could you explain that
in numpty language and also if you could state where to go and how to do it I
would be extremely greatful
 
can someone please answer my previous requests or I will =have to start this
discussion again thanx
 
You must log in or register to reply here.

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

Access Access 2010: Activating controls in a form after filter by form 0
Need combo box to refresh when moving to new record 2017 1
Access Sum function in an Access Form 1
Refreshing filter on Subform in Access 2010 0
Filter by Last Name and First Name 2
Form Filter will not delete 2
filter by form in Table or Query 1
Filtering Subform using option buttons on main form 3

Back
Top