Form problems

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I'm having a big problem with forms. I have 5 forms (each
directly from 5 tables) that are connected with a
relationship. There is a one-to-one relationship with
Field A, which is on every form. On the main form, I have
information that I use to filter and search (Field B, Field
C, Field D, etc.), but I'd like to use that same
information to search the other forms without having those
fields directly on those forms. I can't make giant forms
including all the information, because stupid Access
doesn't let me create a big form. If, for example, I
filter the main form for, say, Field B="Joe", let's say I
get 4 records in the filter. How can I get those same four
records in my other forms?
 
Have you tried putting each of the 5 forms as subforms on
a main form that would have each of the fields you want to
filter by?

I'm no expert but you can use SQL in the row source of the
filtered fields on the subform depending on the selections
in your main form. Something like this say for the first
subform:

SELECT FieldA FROM Table1 WHERE (((FieldA)=Forms!
Main_Form.FieldA));
 
Back
Top