H
hagen31
Hello,
Ok here is my problem and I am not sure if I can accomplish what I want let
me know if I can't and I will do it another way. I would like to base this
form off of the main form if possible.
Ok I have a main form called From1 that has 4 subforms that are used to
connect the many to many relationships I have going on. This form works great.
How there is a division called Service that wants a form to search.
They want to search based on 5 main criteria.
1) Type1 - which is really subform1 connected to the main form by the PK and
stored in subfrm1 and table1 and connectiontable1
2) Type2 - a field in the main form and stored in the main table
3) Type3 - a field in the main form and stored in the main table
4) Type4 - a field in the main form and stored in the main table
5) Type5 - which is really in subform2 connect to the main form by the PK
and stored in subfrm2 and table2 and connectiontable2
Then I would like the rest of the information about this type to appear.
Another way I was thinking was to just copy the current form and create a
list of prompts(as search criteria). If there are any ideas I would greatly
appreciate them.
Thanks
Ok here is my problem and I am not sure if I can accomplish what I want let
me know if I can't and I will do it another way. I would like to base this
form off of the main form if possible.
Ok I have a main form called From1 that has 4 subforms that are used to
connect the many to many relationships I have going on. This form works great.
How there is a division called Service that wants a form to search.
They want to search based on 5 main criteria.
1) Type1 - which is really subform1 connected to the main form by the PK and
stored in subfrm1 and table1 and connectiontable1
2) Type2 - a field in the main form and stored in the main table
3) Type3 - a field in the main form and stored in the main table
4) Type4 - a field in the main form and stored in the main table
5) Type5 - which is really in subform2 connect to the main form by the PK
and stored in subfrm2 and table2 and connectiontable2
Then I would like the rest of the information about this type to appear.
Another way I was thinking was to just copy the current form and create a
list of prompts(as search criteria). If there are any ideas I would greatly
appreciate them.
Thanks