A
adullam04-excelgoogle
I have a main form for data entry (binning of different categories of
the subject reports for the purposes of trending). It has numerous
subforms. All of the underlying tables are linked through a field
called "designator". I have numerous subforms because it is the only
way I have been able to figure out how to make multiple entries for
each of the topics covered by the different forms.
For example, I may want to identify multiple "locations" for a given
designator - so I have a subform feeding a separate table to store the
location information.
Here is where I get tripped up. I have a subform called "Form1". This
subform has two comboboxes. The first is called "tybecombobox". The
second is called "subtypecombobox". Both of these comboboxes are bound
to respective fields in a table called "TypeSubType". In a distorted
fashion this works.
Here are the issue that I am having.
1) When I open the main form (and consequently the subform) I get an
input box that askes me to enter a parameter for
Forms!Form1!typecombobox. I don't know why this is appearing or for
which record in the underlying tables it would want me to enter the
parameter. I can not determine for which record it applies if I do
enter a number - so I just hit cancel.
My efforts to figure this out have taken me to look for events that
might address this while loading. I find nothing. The main form does
not have an event associated with loading. The Form1 subform does. It
only says:
If IsNull(Typecombobox) Then
Call Typecombobox_AfterUpdate
End If
- but the typecombobox is not blank (at least for the first record)
2) The value entered previously into the typecombobox is visible when
the form reopens, but the value previously selected in the
subtypecombobox is no longer visible. I would like to fix this as
well.
Any wisdom would be much appreciated.
TIA
the subject reports for the purposes of trending). It has numerous
subforms. All of the underlying tables are linked through a field
called "designator". I have numerous subforms because it is the only
way I have been able to figure out how to make multiple entries for
each of the topics covered by the different forms.
For example, I may want to identify multiple "locations" for a given
designator - so I have a subform feeding a separate table to store the
location information.
Here is where I get tripped up. I have a subform called "Form1". This
subform has two comboboxes. The first is called "tybecombobox". The
second is called "subtypecombobox". Both of these comboboxes are bound
to respective fields in a table called "TypeSubType". In a distorted
fashion this works.
Here are the issue that I am having.
1) When I open the main form (and consequently the subform) I get an
input box that askes me to enter a parameter for
Forms!Form1!typecombobox. I don't know why this is appearing or for
which record in the underlying tables it would want me to enter the
parameter. I can not determine for which record it applies if I do
enter a number - so I just hit cancel.
My efforts to figure this out have taken me to look for events that
might address this while loading. I find nothing. The main form does
not have an event associated with loading. The Form1 subform does. It
only says:
If IsNull(Typecombobox) Then
Call Typecombobox_AfterUpdate
End If
- but the typecombobox is not blank (at least for the first record)
2) The value entered previously into the typecombobox is visible when
the form reopens, but the value previously selected in the
subtypecombobox is no longer visible. I would like to fix this as
well.
Any wisdom would be much appreciated.
TIA