Is it possible? How? Changing Subforms based on Combobox selection

Hello all,
I am working on a database that has the same info needing selected (thus the main form) then a subform that would open based on a selection in the main form (combobox) ie: if I select a code of ADM-1 then this would call the form based on that items criteria. This is a fluid item. Additionally, I have two subforms -1 with patient data and yes/no fields that will be populated based on a SQL import from a external db, the 2nd subform are questions that would be answered based off of the imported data (calculations, etc.)

I am starting to believe I have made this more complicated but there are many "unlike" data elements per "measure" that I have to record.
Any thoughts? Ideas?
Thanks!

Hi kath007,

Yes it is possible, and yes it might be complex at the same time. But first, to get your first subform to display the records from your combobox selection, it will require that your subform be filtered by the selection made in your combobox. Or base your subform on a query that has a criteria based on what is selected in your combobox. Then after the combobox selection was made, requery your subform to display the selected records. As far as the two remaining subforms, the patient and question subforms, what is the relationship between those two forms and either the main form or subform? What criteria sets up the sql from your form. I think I understand that the sql will be based on what was selected in the main form combobox to get patient data, but I can't visualize the Yes/No fields being used as a filter for the questions subform unless I misunderstood and the question subform always has the same questions regardless of what is in the Yes/No fields. Last, when you say "unlike" data elements per "measure", what exactly does that mean?

lwells

Hi Lwells
Sorry I did not reply - have been overwhelmed with many projects. In any case, what I have is a data entry system. I haven't crossed the bridge of displaying the data based on the combobox, however, just the entry of the data. The display of the data will have to be compiled (maybe a pivot formatted form?) and right now I am just trying to determine the based way to have the forms appear based on the selection. To give you some details, I have performance indicators (PI) - most of which are based on entries from patient data. I have setup a 'main form' with the combo box which allows the user to select the PI they are wanting to enter. This then calls a subform which contains two forms - subsubform1 for the patient specific clinical data, the other -subsubform2 (ssfrm2)- is percentages and counts of that data and other criteria based on the answers in subsubform1 (ssfrm1). (The ssfrm2 is not a 'count' per say of the ssfrm1 thus ssfrm2 cannot just have a query tallying the results on ssfrm1. It is hard to explain -so I hope this makes sense. In any case, I was going to have all 30 forms (yikes!) called as 'visible' when the selected PI (which would equal the subform) was selected, however, I am concerned about memory issues this may cause. Does this make sense?

Hi Kath007,

Honestly most of it made sense except the part of opening 30 forms. I can't even imagine why that is even necessary. How many tables are involved in what you are trying to do, if you don't mind me asking. The reason, is that more than likely, the data can be filtered by the selections within a query to get your recordsource for your second subform. Then depending on how you want the data displayed, such as a pivot table the data would be available. If you like, you can zip me a copy of the database and I will take a look at it and see if there isn't an easier way to accomplish what you want. I just can't imagine trying to open 30 forms as a solution.

lwells