|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 19th, 2005, 10:40 PM
|
|||
|
|||
expressions referring to tabbed subforms
Hello,
I have a subform on a tab in datasheet view. There is also a button on this tab which opens up a form which populates the table the subform is driven from. I would like to have the subform auto-refresh after the populating form is closed, but can't figure out how. I think most of my trouble is that I don't know how to write an expression referring to a tabbed subform. is it "mainform!subform.form"? or is it something else? Help!? 
|
|
#2
August 20th, 2005, 12:55 AM
|
|||
|
|||
|
The reference to controls on a tab page ignore the presence of the tab page.
Refer to them just as if the tab page were not there. -- Ken Snell MS ACCESS MVP "Ericksc" wrote in message ... Hello, I have a subform on a tab in datasheet view. There is also a button on this tab which opens up a form which populates the table the subform is driven from. I would like to have the subform auto-refresh after the populating form is closed, but can't figure out how. I think most of my trouble is that I don't know how to write an expression referring to a tabbed subform. is it "mainform!subform.form"? or is it something else? Help!?
|
|
#3
August 22nd, 2005, 04:07 PM
|
|||
|
|||
|
So is the expression i'm using correct? or do I need something else? What
event would be good for this? "Ken Snell [MVP]" wrote: The reference to controls on a tab page ignore the presence of the tab page. Refer to them just as if the tab page were not there. -- Ken Snell MS ACCESS MVP "Ericksc" wrote in message ... Hello, I have a subform on a tab in datasheet view. There is also a button on this tab which opens up a form which populates the table the subform is driven from. I would like to have the subform auto-refresh after the populating form is closed, but can't figure out how. I think most of my trouble is that I don't know how to write an expression referring to a tabbed subform. is it "mainform!subform.form"? or is it something else? Help!?
|
|
#4
August 22nd, 2005, 06:08 PM
|
|||
|
|||
|
If you want to requery the subform, use this:
Me.Subform.Requery where Subform is the name of the subform control (the control that holds the subform object). -- Ken Snell MS ACCESS MVP "Ericksc" wrote in message ... So is the expression i'm using correct? or do I need something else? What event would be good for this? "Ken Snell [MVP]" wrote: The reference to controls on a tab page ignore the presence of the tab page. Refer to them just as if the tab page were not there. -- Ken Snell MS ACCESS MVP "Ericksc" wrote in message ... Hello, I have a subform on a tab in datasheet view. There is also a button on this tab which opens up a form which populates the table the subform is driven from. I would like to have the subform auto-refresh after the populating form is closed, but can't figure out how. I think most of my trouble is that I don't know how to write an expression referring to a tabbed subform. is it "mainform!subform.form"? or is it something else? Help!?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Disappearing Subforms | Bryan | Using Forms | 0 | March 3rd, 2005 02:17 PM |
| Subforms crash using ODBC | Dick Kusleika | Using Forms | 0 | January 11th, 2005 08:35 PM |
| Two subforms referring to the same table. | Ben | Using Forms | 0 | November 10th, 2004 12:19 PM |
| Some subforms going out of sync, others not | Michael D. Adams | Using Forms | 1 | August 26th, 2004 02:10 PM |
| Tabbed Subforms | Ron | Using Forms | 1 | July 9th, 2004 07:40 PM |
Linear Mode
