Subform problem

Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on the
previous tab control page (there is 3 tabs) as additional information needs
to be entered. The only way I can get the subform to display the information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae

Serendipity,

Try requerying the subform:

[frmItemsChosen].Requery
(that is if thr subform control name is frmItemsChosen)

or

Me.Refresh if that doesn't work.

God Bless,

Mark A. Sam



"Serendipity" wrote in message
...
Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on the
previous tab control page (there is 3 tabs) as additional information
needs
to be entered. The only way I can get the subform to display the
information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc
with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae

Okay.. now I can do it if I click on the background of the tabs but not the
actual tab?? Any reason why I can't get it to work on the tab ( I actually
them as buttons versus tabs). The me.refresh that is. The
[frmItemsChosen].Requery I wasn't able to get the macro to work. I did both
of them on click.

Thanks,
Kenirae
"Mark A. Sam" wrote:

Serendipity,

Try requerying the subform:

[frmItemsChosen].Requery
(that is if thr subform control name is frmItemsChosen)

or

Me.Refresh if that doesn't work.

God Bless,

Mark A. Sam



"Serendipity" wrote in message
...
Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on the
previous tab control page (there is 3 tabs) as additional information
needs
to be entered. The only way I can get the subform to display the
information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc
with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae

Try it in the Chage event of the tab control

"Serendipity" wrote in message
...
Okay.. now I can do it if I click on the background of the tabs but not
the
actual tab?? Any reason why I can't get it to work on the tab ( I actually
them as buttons versus tabs). The me.refresh that is. The
[frmItemsChosen].Requery I wasn't able to get the macro to work. I did
both
of them on click.

Thanks,
Kenirae
"Mark A. Sam" wrote:

Serendipity,

Try requerying the subform:

[frmItemsChosen].Requery
(that is if thr subform control name is frmItemsChosen)

or

Me.Refresh if that doesn't work.

God Bless,

Mark A. Sam



"Serendipity" wrote in message
...
Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on
the
previous tab control page (there is 3 tabs) as additional information
needs
to be entered. The only way I can get the subform to display the
information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc
with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae

Awesome.. you are fantastic!



"Mark A. Sam" wrote:

Try it in the Chage event of the tab control

"Serendipity" wrote in message
...
Okay.. now I can do it if I click on the background of the tabs but not
the
actual tab?? Any reason why I can't get it to work on the tab ( I actually
them as buttons versus tabs). The me.refresh that is. The
[frmItemsChosen].Requery I wasn't able to get the macro to work. I did
both
of them on click.

Thanks,
Kenirae
"Mark A. Sam" wrote:

Serendipity,

Try requerying the subform:

[frmItemsChosen].Requery
(that is if thr subform control name is frmItemsChosen)

or

Me.Refresh if that doesn't work.

God Bless,

Mark A. Sam



"Serendipity" wrote in message
...
Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.
3) The subform is on a tab control page.

The information that the query retrieves is based on items entered on
the
previous tab control page (there is 3 tabs) as additional information
needs
to be entered. The only way I can get the subform to display the
information
entered is to go to design view and back to form view.

I have tried macros to refresh the query, close and open the form, etc
with
no luck. What am I doing wrong? How do I get the information to display
without going to the design view? I would like the information to
automatically display when you click on the tab control rather than
displaying a blank subform.

Any help is greatly appreciated.
Kenirae