Form Filter

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.
 
M

Marshall Barton

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").

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.
 

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

Top