Viewing data entered via Forms 1

[netrusher]

I have 4 forms tied to one table. I use autonumber to identify a form by the number assigned by access. This
way someone can refer to a particular form and info that was input by that form. I inherited this database so
I cannot go back at this time to ensure normalization. I have a field in the talbe called FormType that is
automatically populated to show which of the 4 forms the data came from. Current when any of the forms
are openend and records are viewed via the form each form will show every record no matter if that particular
form was used to input the data. What I would like to accomplish is the following:

When a Form is opened, I would like for only data entered by that Form (identified the FormType) to be able
to be viewed by that Form. How can I do this?

 

[PHV]

You don't know how to filter the RecordSource of a bound form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[onefootout]

I'm sure there's a fancier way, but I'd do it like this:

Make a new query for each form based on that main table. Then filter the query by the formtype that matches the data you want to see. Then set the datasource for each form to the corresponding query.

HTH

K

 

[netrusher]

PHV,

If I do I do not know it. I have never filtered via a Form
that I know of. I see the filter field in properties but
do not know how to do it. I have used help and am searching
via google but still am confused.

 

[netrusher]

If this could be accomplished using the Filter property of the form, how do I input that I would like to filter
based on Field FormType and only want to see records where FormType = M-P?

 

[netrusher]

I currently have the below in the Filter Properties of
my Form. But when going through Records on this Form I am
still showing records that have other than M-P in the
FormType field. Any suggestions?

((AllPartsChangeTbl.FormType="M-P"))

 

[PHV]

In the Load event procedure of the form:

Me.Filter = "AllPartsChangeTbl.FormType = 'M-P'"
Me.FilterOn = True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks very much PHV. This is a big help and I will remember
for the future.