Form Filter

  • Thread starter Thread starter Bill Mills
  • Start date Start date
B

Bill Mills

I have a logon form that a user inputs a logon id and
password. This verifies against a "userid" table that has
the user logon id, password, and their region they are
in. I have another form based on a different table
called "FireEvent" that has alot of information including
region of the fire, type of fire (i.e. "false alarm"),
date of the fire, etc. I am trying to have the second form
display only the data that is filtered by the users region
(who ever logged in) and the type of fire (i.e. "false
alarm"). Any help would be greatly appreciated. Thanks.
 
Bill said:
I have a logon form that a user inputs a logon id and
password. This verifies against a "userid" table that has
the user logon id, password, and their region they are
in. I have another form based on a different table
called "FireEvent" that has alot of information including
region of the fire, type of fire (i.e. "false alarm"),
date of the fire, etc. I am trying to have the second form
display only the data that is filtered by the users region
(who ever logged in) and the type of fire (i.e. "false
alarm").
Click to expand...

Use a criteria for the Region Field in the second form's
record source query:

=Forms("logonform").regiontextbox

The logon form must remain open, but it can be invisible.
 
Back
Top