How can I refresh the master form from a subform?


On the After Update of the subform I am trying to refresh the Master form. I 
have tried things like Docmd.requery and Me.Refresh, but not sure what I am 
Can you help me with this?

5/11/2010 3:21:01 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 32

Iram wrote:
>On the After Update of the subform I am trying to refresh the Master form. I 
>have tried things like Docmd.requery and Me.Refresh, but not sure what I am 

Try using:
MVP [MS Access]
5/11/2010 4:27:45 PM

Similar Artilces:

Some OWA users cant login but some can
We upgraded to Exchange 2003 from 5.5 and rolled out OWA. Some of the users can access the OWA system, But some cant. What should I check? Are the mailboxes all on 2003 yet? Are you still in mixed mode? How long ago did you migrate the mailboxes? I've experienced a similar situation where I needed to wait for either SRS or the ADC to replicate information for migrated mailbox before OWA could be used. This took up to an hour sometimes. Also, did you check the permissions of the user account to make sure they have access to OWA? I am having the same issue. It has been 3 weeks f...

Can I delete OE and just use Microsoft Outlook 2002
I would like to delete Outlook Express is this advisable? I am going to be using Microsoft Outlook 2002 which I recieved w/Toshiba PDA and already have it set up on the same PC as OE. Can I use Microsoft Outlook for multiple e- mail accounts? Differences Between Outlook and Outlook Express;EN-US;q257824 With Outlook, you can integrate and manage e-mail from multiple e-mail accounts, personal and group calendars, contacts, and tasks. "Delia Marlowe" <> wrote in message news:780901c4025...

How can I use my calendar and other features wo using Outlook emai
I have Windows7 OS. I upgraded to MSO 2007. I cannot access the calendar, etc. without setting up an email profile which my ISP will not allow using the email address. How can I use my calendar and other features without using Outlook email? I could use the calendar on previous versions without setting up an email account. Why can't you use Outlook w/o a mail profile? What happens when you try? -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question:

Can't Change Text direction in office 2007
Hi, i have installed office 2007 ( Pro Plus Edition) on a machine. i have faced a strange thing that i have never seen. the option of changing text direction from right to left or left to right does not exist. it come by default with ltr direction. What's the Problem ? Hi, You need to enable a right-to-left language, such as Hebrew or Arabic. To do this, perform the following steps: 1. Close Word. 2. Click Start, click All Programs, click Microsoft Office, click Microsoft Office Tools, and then click Microsoft Office 2007 Language Settings. 3. In the "Available...

How can I put a text box in every cell?
Two questions: -How can I put a text box in every cell that I am using WITHOUT having to insert on manually every time? AND - How can I make sure that a text box inserts itself automatically into a new row whenever I add a row? Thanks! One way is to select the row with the text box and copy it to the next row. Copy and paste it several times and then select the rows and paste them as a group. "bmowell" wrote: > Two questions: > > -How can I put a text box in every cell that I am using WITHOUT having to > insert on manually every time? &g...

Auto Populate a form field
I have two tables with 1:1 relationship. Both have same key field (SS Number). There are two forms, one for each table. When I open Form A there is a button to open Form B. When Form B opens, I want SS Number field to equal the SS Number on the current record in Form A. How do I do this? Thank you in advance. Well, IMO the easiest way would be to make Form B a subform of A, and linking via the common key. Or you could make Form A a tabbed form, and A would be the first tab and B would be the second. Just a couple of random thoughts... "A Bit Frustrated&quo...

Office Outlook
Hi, my office outlook is not working properly, error message : "the procedure entry point GETiums could not be located in the dynamic link library MSDART.DLL " . what should I do?? pls advise. Thanks. Download and install the latest version of MDAC from Microsoft. -- Robert Sparnaaij [MVP-Outlook] Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "david" <> wrote in message > Hi...

Can not empty clipboard #2
I have started getting a strange message in several of my MAC Office products including Word and Excel that says Can Not Empty Clipboard. I also can not copy and paste in any program including Safari. Does anyone have any ideas? Thanks harper6702 Reboot and then run Disk Utility Repair Permissions. The clipboard is a file. I suspect it has overflowed or become corrupted. The reboot may take a long time: during a reboot, Unix cleans out its temporary files, and that may fix the issue... If it doesn't, I have no idea :-) On 16/11/06 2:17 PM, in article 1163647035.202984.70550@m73g2...

Can't save new contacts in Outlook 2007
When I try to save new contacts in Outlook 2007, I get an error message: "Could not complete the operation. One or more parameter values are not valid." It's been suggested that I clear the forms cache but cannot find how to do that in 2007 (recommended link was for 2003 version). Can anyone help with that or is there another possible solution? P.S. I am working off line in Outlook, if that matters. Also, I can revise and save revisions to existing contacts with no problem. HJ Why are you starting a new thread? Suggest following the recommendations in ...

How can be detected if an Outlook profile is corrupted ?
Hi, I would like to verify in a program if an Outlook profile is valid or not ( is not corrupted ). Is there a method to do this ? Thanks Valid or corrupted are different things. Valid; account exists Corrupted; errors in mail profile Valid; Test Account button in Account Setup Corrupted; not possible as it can be many many things, you'll know when working with it -- Robert Sparnaaij [MVP-Outlook] Tips of the month: -Creating Signatures -Create an Office XP CD slipstreamed with Service Pack 3 ----- "kistvan" <> wrote in mess...

Can I use Free Excel Viewer 97/2000 in Windows XP?
Microsoft downloads doesn't list the free excel viewer compatible with Windows XP. Is there a free download to view and print excel spreadsheets, that's compatible with Windows XP? Linda The Viewer for Office 97/2000 works fine under Windows XP. Gord Dibben Excel MVP On Fri, 22 Oct 2004 15:11:01 -0700, "Linda" <> wrote: >Microsoft downloads doesn't list the free excel viewer compatible with >Windows XP. Is there a free download to view and print excel spreadsheets, >that's compatible with Windows XP? Linda An...

can not save or view attachments
I can seem to be able to save or view attachments the reason is that it greyed out what do i do to ungrey it?? Thanks See to learn how to get the attachments off. One popular method is Attachment Options from For more information on the security features, see If you use OE, hit Forward on a message and open or save the attachment, then close the message. Or disable it using tools | options | security. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 i...

Can I calculate a field with 2 different filter criteria in one q
Hi, I have a data source table with a customer name field and various metrics fields, I'd like to sum metric "a" based on customer name being like "abc" and another sum of metric "a" where the customer name is NOT LIKE "abc" in one query, but I can't seem to figure this out, but, I'm a novice at this. Best I can figure is 2 different queries, then a 3rd query to bring the two together. Thanks -- Jim jimd wrote: >Hi, I have a data source table with a customer name field and various metrics >fields, I'd like to sum metric &...

How can i print 1 page only??
We have Microsoft Outlook 2002. If an e-mail initially generated by us becomes very long owing to back and forth replies we would like to print only the first page containing the latest reply. However, the only option we are given is to print 'all/even/odd' pages. Some mails we receive which are not initially generated by us however give us the option of which page to print. It is this type of print option we would like to have for all e-mails! its driving us up the wall, there must be a simple way to do it but we just cant find out how! HELP! --------------------------------...

how can I split one cell's data into two cells?
I am using Excel as a database, and have a column with cells with a person's name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have a column with just John in it, and another column with just Smith...but I have NO idea how to do this! Help would be appreciated. Thank you. Please refrain from multiposting, you have answers in one of the 4! newsgroups you posted the same question in. Multiposting is frowned upon and even the MS web interface states so -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions "It ...

Can't send attachments #3
Whenever I try to send any attachment, Outlook 2003 won't finish the send 'task'. There are no other programs running that would restrict this. Messages without Attachments send OK though. How can I fix this? ...

Create Form Dynamically in VBA
Without going into alot of details I need to create thru code and dynamically a FORM in Datasheet View with a recordsource is an exisiting query. Can this be done in code on the fly. I also need code that deletes or purges the same form object. thanks for any help. Why? It is not a good idea. Perhaps if you described what you want to do, we can help with a how. -- Dave Hargis, Microsoft Access MVP "Bret" wrote: > Without going into alot of details I need to create thru code and dynamically > a FORM in Datasheet View with a recordsource is an exisiting query. Can th...

Money 2005 (UK) on Vista
Hi All, Has anyone else had any problems importing OFX files from HSBC into Money 2005 (UK) running on Windows Vista Beta 2? I've run Money as Administrator to update it, and I've tried importing as both the Administrator and normal user. No joy! It seems to think the file is to blame, but I'm not too sure! Any ideas? Sorry if it's been answered recently, I couldn't find this exact problem. Jules Have you tried running the OFX analyzer on the OFX, to check it is valid, and do you have the 1105 update (look at help and check the version number). -- Glyn Simpso...

OnCurrent of Form - Make not visible on condition
I currently have the following code under the onCurrent of my form: Private Sub Form_Current() Dim strSQL As String Dim db As DAO.Database If Me.ID < 0 Then Set db = DBEngine(0)(0) strSQL = "INSERT INTO LastVisitedRecord ( lvCompanyID ) " _ & " VALUES ( " & Me.ID & " ) " db.Execute strSQL Set db = Nothing End If End Sub However, I'd like to add something to it, but have not had success. I'd like the form to evaluate if the NOTES field is empty (which is there but not visible) and if so, make other c...

Split Database, Can't Append to Table
I have a table to which I daily upload financial reports into one table, and run an append query to add those records not already listed in the master table. I recently split the database because of some other random conflicts we began to have once two users began to access the database. I read that splitting might help. Now I am unable to append to the master table using the append query. I get a message that there is a violoation regarding an index, primary key, or relationship. I've also tried to manually cut & paste the records from the results of the append query with n...

Can databases be merged to update data?
Recently, two employees worked on the same database at two different locations on two different workstations. After we entered data into the databases, we cannot seem to merge our information back into one database. Atleast the help files didn't provide a solution here. Can anyone direct us to the appropriate newsgroup if this isn't the site for the answer we are seeking? If you can answer our question and provide us with the information to merge our databases into one of the databases, please help. Thank you in advance. Hi Mark, Working with copies of your databases, u...

Organizational Forms access in Exchange 2003 OWA
There is an HTML convert tool available for Org Forms in Exchange 5.5, but I am unable to find a way to view our Org Forms in our new Exchange 2003 OWA. Does anyone know of a way to view organizational forms in Exchange 2003 OWA? ...

Reinstalled XP, now can't access Outlook mail. #2
We reinstalled XP Pro on our office machine. Now we cannot view our email (Outlook 2002)!!! Now when we launch Outlook it's as if it were a fresh install & we are a new user. HOW CAN WE USE OUR EXISISTING EMAIL ACCOUNT?? ...

set value in subform
I want to use the set value macro to set a control in a subform based on a control in another form. I have three forms: FormA, FormB, FormC. FormC is a subform within FormB. What I want is to be able to enter a value in FormA and then have FormC automatically updated. Currently, if I open FormA and FormC I am able to use the SetValue macro to do this. However, if I open FormA and FormB (recall that FormC is a subform within FormB) and try to run the macro, Access gives me an error. I'm assuming that it is because Access does not think FormC is open (even though it is op...

How can I convert an Excel file to an address book?
How can I convert an Excel file to an address book to import into email? ...