A
Abes
I have a problem that I cannot seem to solve (I think it may have to do with
the location of my subforms).
The situation is like this:
On my 'main form' I have a Tab Control (TabCtrlExpiry) that is the whole of
that forms detail. That TabCtrl has 2 pages, each page has it's own subform
(and TabControls) and each of these subsequent Tab Controls have 4 pages.
In attempt to better represent this:
Main Form ([frmSG2ExpiryDetails]) ---->[TabCtrlExpiry] ---->[sfrmExpiredNow]
(Page1) and [sfrmExpiredLater] (page2)
[sfrmExpiredNow] ---->[TabCtrlExpiryNow] ---->4 Pages: Expiry <1Month
(Page1) and Expiry1-6MonthsAgo (Page2) and Expiry6-12Ago (Page3) and
Expiry>12MonthsAgo (Page4) - each of these pages has it's own subform.
[sfrmExpireLater] ---->[TabCtrlExpiryLater]---->4 Pages: Due to Expire <30
Days (Page1) and DueExpiry-6Months (Page2) and DueExpiry-12Months (Page3) and
ExpiredOnDate (Page4) - each of these pages has it's own subform.
It is the last page ExpiredOnDate (Page4) that is giving me grief.
The subform ([sfrmDueExpiryonDate]) on the page (ExpiredonDate) calls upon a
query ([qrySG2TotalsDueExpireonDate]), which in turn uses a date parameter
passed from a text box ([cboExpiryDate]) in the form ([sfrmDueExpiryonDate])
header. The subform works perfectly when viewed by itself, but when opening
the main form ([frmSG2ExpiryDetails]) a parameter box appears asking for the
[cboExpiryDate] value. Enter a date, the form opens, drill to the
form/tab/page and the data is displayed correctly (for that date). Any
further attempt to enter data into the [cboExpiryDate] causes an error
regarding 'ApplyFilter' actions. The text box ([cboExpiryDate]) has been set
to run a macro to requery the form "After Update". This works perfectly when
form is stand alone. The [cboExpiryDate] format is set to medium date.
After reading through this newsgroup I have checked to ensure that the form
is part of the page I believe it is (and not part of the main form or a page
below it). Checking through the tab order of all the pages and subforms shows
this subform to only appear in the correct page.
I used the Expression builder within the query to create the parameter
requirements for the query, which as stated works fine stand alone. I drilled
down through the various loaded forms until I arrived at the correct
[cboExpiryDate] item.
All the other forms display the data as intended but none of them call for
any changeable parameters, they are all built into the subform's query. This
last page is to enable someone to view ahead to a specific date. I have tried
a combo box as well as a text box to no avail.
If someone could advise me of my error, or a way to repair the problem (or
if fact what I am trying to achieve is not possible!!) I would be grateful.
the location of my subforms).
The situation is like this:
On my 'main form' I have a Tab Control (TabCtrlExpiry) that is the whole of
that forms detail. That TabCtrl has 2 pages, each page has it's own subform
(and TabControls) and each of these subsequent Tab Controls have 4 pages.
In attempt to better represent this:
Main Form ([frmSG2ExpiryDetails]) ---->[TabCtrlExpiry] ---->[sfrmExpiredNow]
(Page1) and [sfrmExpiredLater] (page2)
[sfrmExpiredNow] ---->[TabCtrlExpiryNow] ---->4 Pages: Expiry <1Month
(Page1) and Expiry1-6MonthsAgo (Page2) and Expiry6-12Ago (Page3) and
Expiry>12MonthsAgo (Page4) - each of these pages has it's own subform.
[sfrmExpireLater] ---->[TabCtrlExpiryLater]---->4 Pages: Due to Expire <30
Days (Page1) and DueExpiry-6Months (Page2) and DueExpiry-12Months (Page3) and
ExpiredOnDate (Page4) - each of these pages has it's own subform.
It is the last page ExpiredOnDate (Page4) that is giving me grief.
The subform ([sfrmDueExpiryonDate]) on the page (ExpiredonDate) calls upon a
query ([qrySG2TotalsDueExpireonDate]), which in turn uses a date parameter
passed from a text box ([cboExpiryDate]) in the form ([sfrmDueExpiryonDate])
header. The subform works perfectly when viewed by itself, but when opening
the main form ([frmSG2ExpiryDetails]) a parameter box appears asking for the
[cboExpiryDate] value. Enter a date, the form opens, drill to the
form/tab/page and the data is displayed correctly (for that date). Any
further attempt to enter data into the [cboExpiryDate] causes an error
regarding 'ApplyFilter' actions. The text box ([cboExpiryDate]) has been set
to run a macro to requery the form "After Update". This works perfectly when
form is stand alone. The [cboExpiryDate] format is set to medium date.
After reading through this newsgroup I have checked to ensure that the form
is part of the page I believe it is (and not part of the main form or a page
below it). Checking through the tab order of all the pages and subforms shows
this subform to only appear in the correct page.
I used the Expression builder within the query to create the parameter
requirements for the query, which as stated works fine stand alone. I drilled
down through the various loaded forms until I arrived at the correct
[cboExpiryDate] item.
All the other forms display the data as intended but none of them call for
any changeable parameters, they are all built into the subform's query. This
last page is to enable someone to view ahead to a specific date. I have tried
a combo box as well as a text box to no avail.
If someone could advise me of my error, or a way to repair the problem (or
if fact what I am trying to achieve is not possible!!) I would be grateful.