Issue Refreshing/Requery Subform/combo box


I need to be able to refresh or requery (not sure which method is 
appropriate) a subform and combo box in the After Update event or via a 
command button.  I've used the below syntax but the combo box (in this case) 
does not get updated.




4/1/2010 5:27:02 PM
access.modulesdaovba 1670 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 7

Manuel wrote:
>I need to be able to refresh or requery (not sure which method is 
>appropriate) a subform and combo box in the After Update event or via a 
>command button.  I've used the below syntax but the combo box (in this case) 
>does not get updated.

Assuming the main form, subform control and combo box names
are correct, that should work.  Be sure to double check that
you are using the subform **control** name and not the
subform object name.

MVP [MS Access]
4/1/2010 5:47:18 PM

Similar Artilces:

upgrading the OS on Exch2003 box
I have successfully upgraded Exch2000 to 2003. The OS is still Windows 2000 Server. Now I'm ready to upgrade that box to Windows Server 2003. Is there anything special I should note before upgrading, or is there a specific document which addresses any known method or problems ? thanks chrism "chrism" <chris@no_spam> wrote: >I have successfully upgraded Exch2000 to 2003. >The OS is still Windows 2000 Server. > >Now I'm ready to upgrade that box to Windows Server 2003. > >Is there anything special I should note before upgrading, or is there >a...

Office XP Exel
Scenario: User's A,B, C, and D all have access to an excel XLS on a 2003 server. Users A & B have modify rights, users C&D only have read rights. If user A updates the file, the general tab in properties reflect the exact time the file was modified. After user A saves and closes the file, user D goes in. The changes are there, but in the properties general tab, the modify date in an old date (probably the actual creation date). Is this normal ? Any idea's ? ...

Combo Chart
I would like to do a combo chart. Any ideas? TIA Lacreeda Lacreeda - Plot all the data in a chart using the chart type you want to use for most of the series. Select one series you want to change, choose Chart Type from the Chart menu, and pick the chart type you want for this series. Repeat for any other series you want to change. Excel offers some built in combo types, but it's easy to make your own, and you can be much more flexible this way. - Jon ------- Jon Peltier, Microsoft Excel MVP _______ Lacreeda wrote: > I wou...

Excel template issues
I have a user that has a excel template on his network home dir NW 5.1 Server he says that after he creates a new file from that template - he goes to open and it tells him read only access running Excel 2000 thanks ...

Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a customized form for entry into the public folder. All of our clients (all XP Pro, Outlook 2003 with all updates) can get to that folder and use the form without any difficulty except for one. On one computer I get the classic "The messaging interface has returned an unknown error. If the problem persists, restart Outlook." error message. I have tried a repair install, no change. I have tried making a new profile, no change. I have tried adding / removing his PST file (currently he's not even using a pst file...

How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus, I have a assets database (rather uncreatively named "Assets"). I use a form (named "Asset Acquisition Input Form New") to enter new assets. The "Manufacturer" field (combo box name "Manufacturers_ID) on this form is a lookup to a Manufacturers table. What I want to happen is when I enter an item that is not in the lookup list, I want a message box to prompt me to add the new entry to the underlying table, or to cancel and select an item from the list. I have no trouble with the MsgBox command itself. What I don&...

Labels in Formulas requires manual refresh?
I use Labels in Formulas extensively. (Excel 2003 11.5612.5606) That is, I tick off Options/Calculations/"Accept Labels in Formulas" and then use whatever text string I've placed at the top of a column of data to refer to it. It has many benefits over Named Ranges, dynamic or otherwise for my purposes, but one ongoing annoyance. When I add data to the bottom of the column of data, the in-cell formula using the label for reference does not change when it should. Workaround: Select cell, F2 or double click to open it, Enter. I have a number of such formulae so updating can be ...

E-mail box sizes. Echange System Manger.
Hi. Now and then I need to find out the size of the various e-mail boxes in Exchange2000. The problem is that the size indicated in the Exchange System Manager do not reflect the same size when you look into Outlook. Is the a way to figure out the correct e-mail size? If not. Is this better in Exchange2003? Thank you in advance. DagN I'd consider the Exchange value to be the most important given this is what will be used for mailbox quotas, etc. Nue "Dag N" <> wrote in message news:OjCaWfjLGHA.2320@TK2MSFTNGP11.phx.gbl... > Hi. > Now and then ...

Refreshing from Outlook (outgoing/Ingoing mail)
It seems I always have to press F5 to check for incoming and outgoing mail (I am dial-up) and then it looks for new mail....Is there a way to get it to constantly check for new mail every few minutes??? I already have the option to "check for new messages every..- minutes." but it doesn't seem to work.. - Can anyone elighten me as to how to get outlook to check for itself?? What version of Outlook? Make sure Outlook is not placed in Off-line mode as well; File-> Work Offline -- Roady [MVP] Microsoft Office and Microsoft Office related News Also Ou...

Terminal Servers in Cluster - Login/Profile Issues
Hello Gurus, Currently I am having an issue with logins and profiles as per details below. Server/Network Configuration Details: 1 X Windows Server 2008 Std FE 64bit (DC) 2 X Windows Server 2008 Ent 32bit Terminal Servers User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain Controller and C:\Users\ on the Terminal Servers. Approx 50 users. Problem Description Error messages when logging in the terminal servers: Your roaming profile is not synchronized correctly with the server. Windows will load your previously-saved local profile instead. See the pre...

Issue with Loan Accounts
Hi Everyone, I have been having this issue for a while - but just now trying to figure out what's happening. I have several loans (including car, equity, etc.) which I have set up on Money 7. Sometimes the interest and principle are calculated correctly - but more often, the entire sum of the payment is allocated to principle (as viewed in the account register). I've check to insure that the loan is set up okay - and it looks okay to me. Any ideas what's happening to me? Any help appreciated. Thanks. Patrick Hi, I was really hoping someone would respond to this. My ...

Subform question 04-09-10
I have a form (Form1) that contains a subform (Subform1). Within this subform I have a combo box which, depending on what is chosen, pops up another form (Popup1)for additional information. I need this additional information in the form that pops up to be 'linked' with the subform. The problem I am running into is that when the user enters information in Popup1, the table has not been populated witht he data that is in the subform so there is no record to 'link' to. What is the best way to force te esubform to pass its information to the table? Thanks i...

Multiple Language Issues
Hi all, Has anyone successfully manually updated a non-English supported 5.5 to 2003? (The reason for the manual update was a broken admin account.) Mail and contacts were all exported to PST files, and then imported to 2003. However, although the text of the messages is fine (English and Russian), the text for contact names and message subjects gets gorched if they contained any Russian text. Does anyone know the correct sequence to follow to take messages and contacts in Russian (or other languages) from 5.5 to 2003, while retaining the non-English subject lines and contact names? ...

How to return the primary key from a combo box
I have a table containing two columns Column 1: Primary key Column 2: Name. I want to create an unbound combo box that shows the name but returns the PK. I have these properties set: Control source: <is empty> Row source type: table/query Bound column: 1 Row source: <I have a select that returns the desired records> In cboClient_AfterUpdate() I look at debug.print cboClient.Value and I see the name. I need the PK so I can construct the query for the next combo box. How do I get the PK Thanks for the help -- Message posted via http://www.accessmons...

Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks Select the cell and then click on Data | Data Validation. In the dialogue box for Allow click on List, and then in Source you can type "Yes,No" (without the quotes) and ensure that In-cell drop-down is checked. Click OK and then you have it. Hope this helps. Pete On Apr 21, 9:41=A0am, Debi <> wrote: > Hi, I am looking to create a simple drop down box which has yes or no as = the ...

creating nested formulas from drop down box
Hi, I have cell A1 with a drop down box containing 26 available choices. B1 has the dollar amount matching to the choice in A1 using vlookup. E1 totals several cells including B1 together. I want F1 to look at A1 and either enter the number from E1 or NA. Here's billing example: A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 (total of b-d1) F1 is the column for January G1 is the column for February H1 is the column for March, etc If A1 = Jan, then F1 should be $16 If A1 = Feb, then F1 should be NA or $0 This is the formula that has been working so far: =IF((G2="...

anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of the box I have a happy face. I'd like the happy faces to be anchored to their corners so when I enlarge or shorten the box, the faces move along with the text box. Why not create a rectangle, insert the happy faces, group. The problem as I see it would be if you resize, the happy faces could be distorted if you widen or shrink the group. You would always have to re-size proportionally. -- Mary Sauer "Helen" <> wrote in message news:193...

Money 2005 Password Issue
I have been using Money 2005 for about 8 months and suddenly I cannot sign in using my usual passport. The error message is "the e-mail address or password is incorrect". However, I can sign in using the same e-mail address/password pair to hotmail and MSN Money in IE. I've tried KB Q331123 but no luck. Any ideas? More details: 1) I can get into my Money file in offline mode 2) I even tried to change passport password. The new password works in IE, but not Money. "MM" wrote: > I have been using Money 2005 for about 8 months and suddenly I cannot...

"Enabel / Disable macros" message box appears no matter which .xls file the user opens....
"Enabel / Disable macros" message box appears no matter which .xls file I open... I can't find any hidden/empty code in the xls files... Has someone got any experience with this? krgds, Nils Egil Lie Stolt Offshore AS Hi you also have to remove the (empty) modules in the VBA editor. Also check that there're no statements left in the worksheet modules and in the workbook module -- Regards Frank Kabel Frankfurt, Germany Nils Egil Lie wrote: > "Enabel / Disable macros" message box appears no matter which .xls > file I open... I can't find any hidden/emp...

text box email publication
I am a publisher novice. I am trying to develop an e-mail newletter. The templates in publisher have a text box under each article with what appears to be a hyperlink with "more details". I assume this will enable the reader of the email to expand the text box and see the full details of the article. I like this feature as it means that readers only get to see the title and abstract and then can select the articles they want to read in full. Unfortunately I can not work out how to use this function and as usual help is no help. Tim no such feature in Publisher. "kiwi ti...

Native Resolution Issue
I have 298 laptops my section supports and recently we started running into issues with higher native resolutions. Some of our users don't like the higher resolutions because it makes everything too small, so we adjust them to lower reslutions, but the settings revert back to the native resolution whenever the laptops go to sleep, get removed from the dock or if someone else logs onto them. We use HP and Dell laptops with various models. Is there one setting in Windows XP Pro SP3 where we can "turn off" native resolution? Thanks for any help -- J Wilson ...

Issue opening documents in MSOffice 2003
Hello I wonder if anyone can answer my question? I have a new laptop running Windows 7 Pro with Office 2003 and I notice that when I seek to open an Excel or Word file with a .doc, .docx, .xls or .xlsx extension, that Excel or Word opens the file but also an empty window of opens at the same time, e.g. I have two windows of Excel open, one with the document I want and the other is empty. Is this a default action for any reason or a bug? This is more of an anomaly than a major issue but I am curious? Any advice would be welcomed. Thanks Martin O'Shea. "...

subform not refreshing
Hi there, I have a main form with a subform embedded to be able to scroll through a list of records. There is no linking field between the two. The subform displays all the records properly. One of the fields in the subform is a checkbox to 'close' the record indicating that the info is no longer current and shouldn't be displayed. This works fine. I should also mention that the subform is based on a query. I have a button on the main form which opens another modal form based on the same query as the subform that will let me uncheck the checkbox in case the record was 'clo...

File Open Box
When I go file open and the box appears to select where & what I want to open, it appears full screen, how can I reduce the size of it (it never used to be full screen). I try placing the mouse on the edges but it won't give me a drag arrow from anywhere around the perimeter of the screen Drove me near insane once. Dbl-click in the dialog title bar. "bev" <> wrote in message > When I go file open and the box appears to select where & what I want to > open...

Combo box from a macro
Hello, First let me give you the scenerio. I have a main form of data. On it I have a subForm. I want to select a record from the subform (which is sub-data) and display that record in the main form. This is a customer and related customer DB. When Customer X comes in I want to be able to see customer x's family. I want to be able to choose a mamber of custome x's family and display them on the main form, thus displaying customer y and their family. I have created the main form to have a combo/lookup based on the SS#. I have created a button on the subform to read the SS# on ...