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
 
Back
Top