G
Going Crazy
Hi. I'm working on a physician profile database. The
main form (PhysicianMain) is unbound and has 3 combo
boxes: one for the month, one for the year, and one for
physician ID#. There is a wide variety of data that will
be displayed once those 3 data elements have been entered
(such as number of admissions, number of discharges,
number of surgeries, number of deaths, etc.), so
therefore I have a number of tables that house this
information and therefore will be using a series of
subforms to display this information.
Here's an example of the problem I'm having:
I created a simple subform (SubformAdmits) with one
control. It's a text box named TxtAdmits. The subform's
record source is query (GetAdmits) that queries the table
that holds the admit informtion (AdmissionsTbl). Based
on the month, year, and physician ID# selected on the
main form, the query simply returns the total number of
admits. I simply want the text box to display the result
of the query. After making selections from the combo
boxes on the main form, the subform remains blank. Since
the main form is unbound, there is no link between the
main form and the subform. I'm not sure if this is the
problem or not. As an alternative, I could just place
text boxes on the main form and use a 'Dlookup' command,
but I thought a subform based on a query might be more
efficient.
Any help that you can provide is very much appreciated.
Thank You.
main form (PhysicianMain) is unbound and has 3 combo
boxes: one for the month, one for the year, and one for
physician ID#. There is a wide variety of data that will
be displayed once those 3 data elements have been entered
(such as number of admissions, number of discharges,
number of surgeries, number of deaths, etc.), so
therefore I have a number of tables that house this
information and therefore will be using a series of
subforms to display this information.
Here's an example of the problem I'm having:
I created a simple subform (SubformAdmits) with one
control. It's a text box named TxtAdmits. The subform's
record source is query (GetAdmits) that queries the table
that holds the admit informtion (AdmissionsTbl). Based
on the month, year, and physician ID# selected on the
main form, the query simply returns the total number of
admits. I simply want the text box to display the result
of the query. After making selections from the combo
boxes on the main form, the subform remains blank. Since
the main form is unbound, there is no link between the
main form and the subform. I'm not sure if this is the
problem or not. As an alternative, I could just place
text boxes on the main form and use a 'Dlookup' command,
but I thought a subform based on a query might be more
efficient.
Any help that you can provide is very much appreciated.
Thank You.