subforms

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

I have a main form and a subform,the subform is linked to
the main form. On a different form, there is a combo box
(data from the subform) that the user can select, and then
click on the command button. This should open the main
form based on a criteria from the subform. Can this be
done?

Thanks.
 
I have a main form and a subform,the subform is linked to
the main form. On a different form, there is a combo box
(data from the subform) that the user can select, and then
click on the command button. This should open the main
form based on a criteria from the subform. Can this be
done?

Thanks.
Click to expand...

You say "data from the subform". This is a common error of perception!

A Form (or Subform) is a *tool* to enter data into a Table. It doesn't
contain any data, any more than my office window contains the Owyhee
Mountains. Therefore the combo box *cannot and does not* contain "data
from the subform". It contains data from a Table (which may or may not
have been populated using that subform as a tool).

Could you explain how the button should work? "open the mainform based
on criteria from the subform" is perplexing to me. What are the
Recordsources of these three forms?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
On one form which I call it the "search form". You are
right, the combo box(unbound) contains the types of
Training from a table (using select statements).

On the main form, it is getting data from a table that
shows the name of people and department.

On the subform (continuous form), it shows the different
types of training these people have which is linked to the
main form.

What I am trying to do is when I select a type of Training
(ie. orientation) from the combo box on the Search form, I
want the main form to only show people who have taken the
orientation. It is comparing the training from the combo
box on the search form and the training field in the
subform.
 
Back
Top