Open specific form based on data in a column from a continuous form

[kyle91202]

I have a continuous form in Ms Access and I would like to click on a row of data and open a specific entry form based on data in a column. For example I have a column called fruits and and I would like to click on a specific fruit name (pear) and the entry form for Pear opens. If the column is "apple" the apple entry form opens and so on....

Thank you so much.

Kyle

[kyle91202]

Oh there are only 10 different entry forms.

[pbaldy]

Why all the forms? If you have different tables for each fruit, that's generally a design problem:

Fundamentals of Relational Database Design -- r937.com

What you describe is possible, but unusual.

[kyle91202]

My project is medical chart abstraction. I want the nurse to be able to search in a continuous form on the patient and if member is required for breast cancer screening the breast cancer screening form pops up for the nurse to abstract the data from the charts. If member needs cervical cancer screening the nurse would click on the row and the cervical cancer entry form will pop up and nurse would abstract the data into the form. There are 10 different types of preventive measures for abstraction. I hope this makes sense. Thanks

[pbaldy]

Well, you've substituted medical tests for fruits, but not addressed why the need for different tables/forms. Presuming the data is different enough to justify it, you'd somehow have to associate the value on the form with the name of the form to be opened. One way would be a combo box that showed the name of the test to the user but in a hidden column contained the name of the form. In that instance:

DoCmd.OpenForm Me.ComboName.Column(x)

where x is the zero-based column containing the form name.