Refresh 1 subform from another

I am trying to refresh a subform from another subform and I cannot seem to 
make it work.  I have a button on subform 2 that needs to have subform1 
refresh.  I used

Me.subform1.mainform.form.refresh and I get an error that says Method or 
Data Member not found.  Anyone know what I did wrong?  I am thinking I should 
use ! instead of . but I don't know what the difference is between them.  Any 
help?

-- 
Thanks As Always
Rip
0
Utf
6/7/2007 3:39:02 PM
access.formscoding 7493 articles. 0 followers. Follow

1 Replies
1093 Views

Similar Articles

[PageSpeed] 54

Ripper wrote:

>I am trying to refresh a subform from another subform and I cannot seem to 
>make it work.  I have a button on subform 2 that needs to have subform1 
>refresh.  I used
>
>Me.subform1.mainform.form.refresh and I get an error that says Method or 
>Data Member not found.  Anyone know what I did wrong?  I am thinking I should 
>use ! instead of . but I don't know what the difference is between them.  Any 
>

Your object heirarchy is backwards.

Parent.subform1.Form.Refresh

-- 
Marsh
MVP [MS Access]
0
Marshall
6/7/2007 3:52:58 PM
Reply:

Similar Artilces:

Set focus in a specific record within a subform
I have a main form with a subform. The subform contains multiple records and a hidden unique id which ties it to the main form. After I enter data into a field on the subform, I am requering the main form. I would like the focus to remain on the subform on the specific record the user is editing. I have been able to get the focus to remain the subform however, the focus jumps to the first record. Any ideas? This is my code: Private Sub MP_Reserve_AfterUpdate() Forms!Liability.Form.Requery Forms!Liability!ClmntInfoForm!.SetFocus Forms!Liability!ClmntInfoForm!.Form![BI ...

550 5.1.1 user unknown
We have a client that gets the error below intermittently. I have worked with this client's IT staff over the phone to help resolve the issue. The thing is is that they can send e-mails to us half the time and the other times they get the message below. This happens to all users within our organization with this client. They client's IT staff seems pretty comfortable that it is not their end but this is the only client we have problems with. Does anyone have any suggestions as to what could be causing this? If so, any advice would be appreciated. thanks! Sent <<&...

how do i refresh or sync all?
I am trying to force my mail to refresh, or to look for new mail much like Outlook Express does when you click on "Sync All". Maybe I shouldn't be concerned with this. Does Outlook deliver mail as soon as it is processed by the server or is it sent at preset intervals set by the administrator? Les perhaps you mean Send/Receive ? Still learning wrote: > I am trying to force my mail to refresh, or to look for new mail much like > Outlook Express does when you click on "Sync All". Maybe I shouldn't be > concerned with this. Does Outlook de...

Outlook 2003 and Palm3.0.1
My old Palm will not sycn to Outlook. Is there a free patch? I know I can buy PocketMirror from Chapura. See if Palm has an update to their software for Outlook 2003. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "henry_altman@hms.haarvard.edu" <anonymous@discussions.microsoft.com> wrote in message news:0de801c3a9fe$e4822e70$a501280a@phx.gbl... > My old Palm will not sycn to Outlook. Is there a free ...

Refresh some not Refresh All
Hello. I have a workbook with 10 sheets all of which have external data that needs to be refreshed periodically. Most of the time I only need to refresh 8 of the sheets. Is there a way to refresh just those 8 without having to refresh each one separately? Thanks in advance. You can use a macro to do it. It would go something like this... Sub RefreshSome() Dim wks As Worksheet Dim qt As QueryTable For Each wks In Worksheets Select Case wks.Name Case "Sheet1", "sheet2" Case Else For Each qt In wks.Que...

XML The data at the root level is invalid. Line 1, position 1.
Im getting this error while trying to read a xml file that i receive from a POST heres the code: Dim MyXmlReader As XmlTextReader Dim strNodeResult As String Dim NodeType As XmlNodeType Dim objwriter As StreamWriter Try MyXmlReader = New XmlTextReader(Request.InputStream) Do While MyXmlReader.Read '*******ERROR HERE ******** NodeType = MyXmlReader.NodeType Select Case NodeType 'Case XmlNodeType.XmlDeclaration 'strNodeResult += "XML Declaration :...

How do I incorporate 2 columns into 1 column
All, My issue is that I have 2 columns of data, Column A and Column B. What I would like to do is combine these 2 columns into 1 that would result in something like this: A1 B1 A2 B2 A3 B3 etc There are 1000+ entries in each column and I have tried creating a 3rd column plugging into the cells the following, hoping to create the ability to click and drag and fill the rest of the relative values: =A1 =B1 =A2 =B2 =A3 =B3 etc However, when I click and drag, I am not able to keep the pattern going. It always seems to revert to something like this after I try to click and drag the fill box:...

Copy to filtered blank rows from another spreadsheet
Hi, I have a spreadsheet that it's filtered to show blanks items in column J, I want to copy into this column J data from another spreadsheet's Column J. is there an easy way to do? Basically, need to copy from spreadsheet 2 column J into the filtered blank rows in Spreadsheet 1 column J . Any help would be greatly appreciated. Thank you ...

Office 10.1.4 update crashes
Hi- I recently tried to install the Office v.X 10.1.4 update on my iBook G3 (I have successfully installed the 10.1.2 update). Near the end of the update, the installer stopped at number 13 (an excel file I believe) and reported an error in attempting to create the file. The installer then stops. Now, none of my office programs will even reach the splash screen when opening. Instead, when attempting to open, they bounce in the dock for a few seconds and then unexpectedly quit. I assume I need to uninstall from the Office v.X CD and then reinstall office and try each of the updates in ord...

Refresh 1 subform from another
I am trying to refresh a subform from another subform and I cannot seem to make it work. I have a button on subform 2 that needs to have subform1 refresh. I used Me.subform1.mainform.form.refresh and I get an error that says Method or Data Member not found. Anyone know what I did wrong? I am thinking I should use ! instead of . but I don't know what the difference is between them. Any help? -- Thanks As Always Rip Ripper wrote: >I am trying to refresh a subform from another subform and I cannot seem to >make it work. I have a button on subform 2 that needs to have su...

VWD2008 will not refresh HTML file
I am trying to use the showmodaldialog function to display help files for my website. But when I make modifications to the HTML file, a previous version of that file is displayed from within the VWD environment, even if I just want to debug that file. I have restarted VWD, but the old version is still displayed. When I double-click that same file outside the VWD environment, the modified version is displayed, so I know the changes are being saved. I have searched the entire hard drive and there is no other file with the same name. ...

Display Count of records from subform on Main form
I need to show a count of records for doc on main form. Doc info is on main form and list of pts is on subform. I have entered an unbound text box on the main form and have tried DCount, ABSSum and Count all I get is 0. This is what I have entered: =DCount([ID]) or ABS(Sum([myfrom].[ID]) and =Count([ID]). Thank you in advance for any help you can provide. Thank you. Try it this way: Create a query with the needed table. Add the id-field to the grid. Total it by Count. Save the query and on the form you place an unbound field. In VBA you can do a Dlookup for the one field in the q...

Cells WON'T stop refreshing automatically
I have a workbook with many worksheets and links that I need to publish externally with links locked so that users won't get the "The workbook you opened contains automatic links..." message. I have gone into <Tools> <Options> <Calculation>, unchecked the <Update Remote References> checkbox, and saved the workbook; however, each time I reopen the saved workbook, the <Update Remote References> checkbox has been rechecked by some mischevious gremlin, and I invariably get the "The workbook you opened contains automatic links..." mess...

Refreshing
Hi !! I ve done a OCX to view certain type of images. The OCX has a dialog in it with buttons. This OCX has been loaded into a html page. When multiple OCX are being placed in the html page I find the images that are displayed flickers. I use invalidate to refresh but refreshing is very fast. What should I do now to make smooth refreshing. Thanx Sudharsan Double buffer the image. Create a memory bitmap, copy to it, the BitBlt to your OCX's HDC. This may increase CPU usage a little. "Sudharsan" <Sudharsan@discussions.microsoft.com> wrote in message news:A72BC9BB-...

Microsoft Dynamics GP 10 Technical Demonstration SERVICE PACK 1
MBS released SP1 of the Demo environment this week. Right now, don't waste your time spending 6 hours downloading the files. The RAR files are corrupt and it's impossible to create the VHD. I've downloaded 3 times on different computers all using a hard line with no difference in the files. Sources have confirmed that other people have been reporting the same problem. I think they are working on the fix. -- Jim Lines Sr. Microsoft Dynamics GP Applications Consultant Certified Microsoft Dynamics GP Specialist The released the new files today. I've yet to try the V...

Web Query Refresh problem
Hi I've set up a workbook that contains about 75 sheets. Each sheet contains a web query. I then have a summary sheet which summarises the actual part of information that I want from each web page. Everything works fine, most of the time. I've set up a little button to 'refresh all data'. However, sometimes the refresh doesnt seem to work on some of the sheets. It actually pulls data from a website which I've set up on a different sheet. If, however, you go to that individual sheet, and manually refresh that sheet, it pulls through the correct data from the web. Som...

AJAX UpdatePanel does not refresh after calling Update()-Method
Hi, I'm new to AJAX and has a little Problem to get an UpdatePanel inside an CustomServerControl to work. My goal is to create an CustomServerControl with an (at designtime) unknown number of UpdatePanels, that can be updated seperatly. Since I'm stuck I create a litte more static testproject to analyse the problem but I ran out of ideas what I could been missing. I would be realy glad if someone can show me hwo to get the UpdatePanels working. I created an ServerControl-Project called ServerControlTest and an ASP WebApplication called AXAJTest The Default.asxp look...

Clipart Woe -- how to refresh location
How can I refresh the path to the clipart gallery for the clipart files? I have moved the clipart from a network location to the local harddrive and rebuild the artgal50.mmc file, but the gallery still looks to the network location?? Help is greatly appreciated, because searching the MS resources is drivining me nuts Nigel Nigel, they are coming to take you away, take you away. If you hear a knock on the front door, do not open it as it may be the fine gentlemen with a while jacket with straps on. Nigel, you are driving us nuts not telling us what version of Windows and Publisher you...

CWebBrowser2 and Refresh
Hi All, I am using CWebBrowser2 control to get values from a website then plot them on a chart. When I use Navigate2(..) I can handle the OnDocumentCompleteExplorer(..) message to parse the html file and update my chart. However, I don't always get an updated page, can someone give me an example of how to use Refresh2(..) to make sure I always get a non-cached page? Also, is there a message sent when Refresh() or Refresh2() has finished? Or maybe there's another way I can achieve what I want? Cheers, Rob ...

3 domains 1 exchange server
Can someone give me a brief overview on how to setup mail for three domains on just the one exchange 2003 server and one AD domain controller. Thanks ...

can't get auto update 1.1.2 to install
I have tried for the last week to get the update 1.1.2 to install on my g3 iMac ,running 10.3.9 It meets all the requirements for office but when I try to install the update it stops at the VISE screen. I tried the auto update and a manual install of this update and it just wont work. I just got office for my daughter to do her school work and I need to install the updates. How can I get past this? How exactly do you go about installing the update? Microsoft AutoUpdate comes with Office 2004, so it should already be on your hard disk. Try running the application to get it to update itself...

Cannot install Microsoft.NET Framework 1.1 Service Pack 1
I receive notice that I have updates to install. When I click on the icon in the taskbar the next screen is the Windows Update. The important update is Microsoft.NET Framework 1.1 Service Pack 1. This update has failed to install every day since 11/12/2009 and numerous other times since the first attempt on 3/16/2009. Most of these failures do not show any error message. Other updates seem to install okay, the only problem I have is with Microsoft.NET Framework 1.1 Service Pack 1. I have Microsoft. NET Framework 3.5 Service Pack 1 installed and I wonder if the 3.5 is a...

Chart source data invalidated when workbook refreshed
Hi all, We have a workbook with vba code which fetches data from the backend and displays it. Now i have a chart defined for some data in this workbook and then i refresh this workbook. The problem is the chart source data is invalidated for the new workbook data. Any solution for this ? Any help is highly appreciated :-) Louis - How does the macro refresh the data? Could you make use of a dynamic chart instead, for example, one that charts the last N points in the table? Here's some Dynamic Charting examples and links: http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics...

Attaching an open email message to another message
Hello, If I have opened a message (call it message-1) by some means (say from some desktop search application) and i'm composing another message (say, message-2), is there some easy way to attach message-1 to message-2? Currently, the only way I know of doing this is to find the Outlook folder where message-1 lives, hunt for message-1 there, and then drag it into message-2. If I already have message-1 opened, is there some shortcut to getting it into message-2? Thanks! No, whether message-1 is open or not has nothing to do with how you = attach it to message-2. --=20 Sue Mosher, Out...

Creating more than 1 line in a cell
Is there any way to create more than one line in a cell? You cannot use the RETURN or TAB keys since they take you to another cell. I tried using three cells and then merging into one, but then it only keeps the information form the uppermost cell and then deletes the data in the other two cells. Text-wrapping doesn't work because if the word(s) on the top line is long enough, then I have to add several spaces before it will be forced to go down to a second line. I've tried Excel Help, but it goes to autoformat and none of the formats are the ones that I want. Thank...