Refresh subform after update If I change to a new record on the main form and There is still one problem wtih this; If you will set the BindingList as source to a editable grid, and the same BindingList(by reference) will be used in another form just for Working with Access 2013 I have a subform that is part of the main report form. After the query run, I have to go back and manually refresh the form for the results to show. In fact, if you check with allforms() the subForm isn't even loaded as far as access is concerned. I found that I've to Now there is nothing wrong with the code above, but instead of putting such code inside each and every form’s After Insert event and every control’s After Update event, I thought to myself that I Here it is. Place the code in the on close event of the form that updates circuit’s disconnect date. You cannot refer to a form object shown in the subformcontrol via the Forms collection. The problem is the subform B that is presenting details from subform A. Set ID column to 0 width. 2. DoCmd. ID change). Form. refresh The thing is though I AM Make that form a subform on unbound form. The two forms are linked via WidgetID. Set the Subform master field as parent This works - I can open the table and see the records in there, but the subform refuses to update and show the new records. Access Subform In this Microsoft Access tutorial we will talk about the difference between Refresh and Requery and when you would use each. All of these subforms work, in so far as they show the details I want, but only after I manually select each subform Page. To requery the form in a subform control on the In this article. form. echo or docmd. So I want to click the Update button and add a new record in the subform "StatusNotes" to store the value of the "Status" field in the main form. What does work is change the "Got A subform and a mainform have nothing to do with each other when it comes to updating. refresh and me. Access VBA code format updating table What I want to do is have a subform populate/refresh anytime an After Update of either of these text fields are adjusted so long as both have values, (i. When a user manipulates the main form, I want I want the save button in this pop up form to update the parent form onClose. I thought my query was wrong until I tried running the query by itself (with the form open If i add a main form refresh after the requery (in the userrole subform it works. Click in the 18878 Hi everyone! As shown above, I have a form with a subform in it. Close . When you move to a subform the mainform is updated (if anything changes) and Hi I have a continuous form which creates an income budget based on 12 fields - Jan thru Dec. That's why I use the update query to update those Probably a common question and I did a search for the answer without much luck. The second combo box's source is dependant on the preceding combo box This is the row source code for combo2 SELECT The second subform (yellow color) igores the date and shows all records of the preselected category. Mainformname. SAVERECORD; CurrForm. Requery a subform from another subform where Remarks. Private Sub Form_AfterUpdate() Your post is somewhat confusing. What code do i need and should it be after Hey everyone, I have a form that has two subforms within it. The subform is in continuous form view. Tried also to refresh after requery but nothing happen. I don't know the source of the records for You might be better off using default-value logic in the subform table, which will reference your main form option group. The fields can be edited. RecordSource = I think, to have the parent form recalculate calculated controls, you could use the following in your subform refresh button event procedure me. If I trigger a change on the main form that causes the In this article. ) It's also why, in many versions of NAV Classic, the Sales It depends on how you are doing this. There are 2 scenarios I've come Hello. I have a form in which a 'read-only' sub form is placed. Commented Nov 11, 2015 at 5:03. requery it works fine, and the subforms requeries From a form "Microsim Work Form" I open an update form. The content of the listbox is showing the The subform is a list of records. In fact, if the recordset didn't change otherwise, you'd end up at the record after the one that's no longer displayed. However, refresh and requery are not the same You don't say where this OnClick Event is, on the subform or on the mainform. Basically, I want to refresh the source objects on the unbound main form. Needed: I Right now the subforms only update if I close and open the form, which is probably not the best solution, since it's too slow. ON OnValidate() trigger CurrForm. You don't "call" a subform from a main form; the subform is part of the main form, actually loads before the main form, and is always present. Code: Forms. In other words, Use the following code to refresh your subform. From the MainForm I call SubForm, and the SubForm changes a field that is shown on MainForm. The code in the combo box that populates the subform works fine. It's just a set of records. Refresh I have also tried to refresh the subforms themselves (example) Age old problem Refreshing a sub form. The subform is based on a query. expression A variable that represents a a me. as soon as i enter the value in B form,form C Access 2003 I have an input form that is based on a single table with combo boxes and the selection of those boxes creates a requisition with a auto number ID. V. To reproduce the issue, open the db, click on the This is a follow-up to this solved thread (sorry, Rural Guy). Requery. Requery Forms!FRMCourseDetails. This way, nothing is set in stone until the user starts I have a combo box ProjectNo in a form NMR_Form. I even have the Macro security setting set to always allow. Xlinesoft forums Toggle navigation. In this form F1 a method called Refreshthisform() is written by me. After the filterfunctions I want to call a CurrForm. net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or In this Microsoft Access tutorial, I will show you how to update the value of one field when another field is changed. Update. I'm certain the SQL you use refresh when you want to refresh the contents of a database (for instance if you add an item to, say, a list of customers, but the new customer does not appear in a If the subform hasn't been scrolled, the current record will default to the first record. PASTE THIS VBA CODE into your The fourth subform works the same way for the third subform. I thought it'd be as simple as an "on activate" event on the main form. Graves #3. Where In the subform , when I click on a certain field, all data of the field apperas on the main form. Update([SaveRecord: Boolean]) Parameters. Name of Hi, I'm running into an issue with my forms. What i've I have the main form "MForm" with 2 subforms "subform1" and "subform2". I am not very familiar with using VBA within access, so I may very well be After each update I can open the subform on its own and it shows records that match the combo box including <ALL> records. USER_AfterUpdate You will find that, after assigning to a strongly typed variable, By FORM. My form has a text box, txtFoo, and a combo box, cboBar. Invoice Subform". The database ID is showing 1. I suspect it's because I'm using CurrentDB. net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other The subform data source is a SQL query I am updating manually. ListCount * 230 + 230 If . If I'm right in thinking that the only way to update my subform is to refresh the subform's RecordSource, is there a quicker way to do this than my 'Alternative' method When updates happen, you will see them because the access form is set to automatically "refresh" the recordsources. On the close event of the update form I want to refresh My desire is to update the filter on the report and requery and refresh the report within the form. Chain of events: 1) User selects item from drop down list on the main form. I tried to do this Hi everyone, I have been having a terrible time trying to get my forms to requery and refresh. A simple refresh should work. Can In your example code Forms!frmResults!frmResultsSub. It does change the first time. I have a If you want to refresh the data, you need to create a public method "Refresh()" and call it. If we I just need the subform to update immedietely after a combobox change. I googled some VBA code but it In this article. requery which worked, but then it jumps to the first record. I have added the following code to the On Current property of my main form. Requery) of the child form, by mean of an event raised from subForm listen on parent About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright I tried the Requery method, but it does not update my form. The mainform is named frmJunction. I have a Subform on a mainform which I refresh using: Private Sub Form_GotFocus() For amendments to the subform's table's records use the subform's AfterUpdate event procedure to execute an SQL statement to update the parent form's current record. 3) if i It should work if you first save the record in the AfterUpdate of the control. I have 3 fields on my form, Since you did not add new records you can use refresh to update the visible records'and ensure that you stay on the current record me. You Refresh. We will also briefly discuss Rep If CurrentProject. it appears access is intelligent enough to know that subform Howdy, I need to refresh an unbound calculated control in a subform on the after update event of another embedded form within the main form - this is turning out to be more of In this Microsoft Access tutorial, I will show you how to immediately update calculations on a form when any single field is updated, ensuring your form data I would look into CurrPage. The record count Running an update query from a popup form to update the record being viewed on the form that opened the popup is dangerous at best. Recalc << Doesn't seem to See whether this description is reasonably close to your situation. How can I either: 1. This doesn't update properly, it's still Question: In Microsoft Access 2013, I've created a combo box that is populated by a code table. Also in NMR_Form is a subform, subfrmPROJECT that is tied to a control in NMR_Form named ProjDef. Recordset. expression. I tried the following code without success. I have a Join form that How do you update a subform in Access? Method #2 – Manually refresh the subform Then click on the button with the three dots to the right of this property. What is the best way to display the new info in the parent However, after the refresh, my cursor jumps from the current field in the sub form that I am editing to the first field in the "current" sub form. Cr. The row source property for cboBar is a query which references txtFoo. I have a button on the main form which On the same lines, the subform of form A is a brief view of the subtable, so to create a new subrecord, the user clicks a button, launches the newvehicle form, creates a new If I select a value in the combobox and click a refresh button that has only the following line of code: me. Update 1: I updated LibreOffice right before posting my original question. Is there a way Subform wont update I have a form with two subforms. Requery In the after update event of the sub form I entered me. When I close the SubForm and The subform’s recordset is a query that contains a mixture of calculated fields and fields from a table (though the majority. When data gets entered into the subform, I have a query that narrows down the data for a I've a main form and a sub form. To start off, I have my database in a user defined trusted location. (In general, it's rather difficult in Classic, but not impossible, to update form related information on Subform changes. NoOfDays = The query is passed to a subform (in typical datasheet view) which is on the bottom of the main form. To elaborate further : Consider there are two forms, I'm trying to update a txt field on my main form, with the after update of a combo on a subform. For example: f2. It is like a refresh problem on the subform. Frm_Main!SubFrm_Name. On subform1 i have 5 tabbed pages: Page1, Page2, Page3, Page4, Page5. idesperately need some helphere. 3. However the subform that is using this query is not refreshing no matter what I try till I reopen the form. Go to the Events tab. I have a form with a subform. A re-query will move/reset the record pointer. I know the record is working since if I switch off to a different tab and come back to it. subformname. ListCount > 2 Method 1# Refresh Data In Access Database. When I edit a field on one subform (or delete a record there), I want all (sub)forms to refresh automatically and inmediately. [Optional] SaveRecord Type: Boolean Set this parameter to true if you Instead of populating the table in the After_Update event for your textbox, try using [subform name]. recalc which is supposed Preface: I have a form which has tabs. The only problem is the ListBox doesn't update and it continues to show every The code works and updates [Status] correctly, but the value on the subform doesn't update. com/AfterUpda B - where are the values that are the cause for needing an update? If A is the MAIN form and B is the sub-form, then the update events are occurring in the sub-form but if no -> code in main_user stops - work in purchasing requirements - close purchasing requirements -> code in main_user starts *from where it stopped*. Post Cancel. You need to create a query that joins the subform's table with the lookup tables and use that as the recordsource for the subform. , AfterUpdate vs OnClick). This forms work well, but when I return to Form1 after having added a new record, the new record doesn’t shows unless I use a control to requery the data. I have a form ('Mainform') that contains a subform ('Subform') that contains combo boxes populated with I have a subform which contains 2 combo boxes. 1. I have totals in the Form I have a subform that I need to refresh or requery to show new total after payments are entered. When in form view I am able to Subform update after changing field on parent form AccessForums. Local time Today, 11:27 Joined Jun 8, 2002 I run an update query from form "B" So I want to save the update in form "A" then refresh subform within form "A" The subform in form "A" is only visible when all the criteria in I have Office 365 on Windows 10. . If you select the Assuming your sub form control on the main form is named ctlSubForm, this would be a code sample you call in the subform, for example in an AfterUpdate event procedure: Here is the code used within a field on the subform run as an after update event. What i'm trying to do is when a particular subform field is updated that the other subform is refreshed. net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, I'm needing to update the Total Time box on frmProject every time either a new record is entered in the subform datasheet view - or when time is adjusted for a previous I have a form which enumerates all the rows in a table and lets you edit them in a subform. it refresh main form data after update from subform Apologies for asking this question again. I want to refresh the data on the main form to refrsh the calculations after It gets a little convoluted with subforms. End Sub . Nov 12 '05, 11:59 PM. It displays the incorrect data, but never changes again. After completing the updates I will close the update form. The macro refreshes both subforms when you hit Enter in the criteria The subform is based on a query which takes a Project_ID and from the combo box and filters the subform table based on that Project_ID number. I thought this would happen automatically and without VBA, but maybe not. Is there any way to do it. i wanted to enter the value in subform B. subForm2. I seek to have something that will To anyone who may come behind me, the method above did not work if you are opening a pop-up from a subform attached to a main form. I can only close and reopen the form. It is very barebones, so it will give you a lot of errors when loading becasue of deleted subforms and tables. End Sub. Page Type: Page An instance of the Page data type. The sub form is based on a query. I have form name called A and i have added two form B and C into form A as a sub forms. I tried the Requery method, but it does not update my form. After I add a new value to the code table it doesn't appear in the combo box list. Private Sub combobox1_bis_AfterUpdate() Me!frmSub. The AfterUpdate event occurs after changed data in a control or record is updated. i have a form,and when someone is scrolling through the records, if they make a change in it, I want the Subform to pull up the addresses associated with the name that is chosen. but also the same problem when the combo1 get new value (Auto) it's not affect the subform Links. Height = . Here is what I have: Background info: Main form = MainMenu; Navigation control In the AfterUpdate event procedure of the first subform call the Requery method of the second subform, using the following syntax: Me. Contains details about a person. UPDATE to refresh the records in the list when changing the filtervalues on the main However, in the body of the subform I have another List (List11) that should show the records associated with the selected Clients in List1, but does not update until I hit a button on the When does this table B update or insert? By user, by automated code, or by outside event? This identifies the type of trigger event (i. Currently I have a button on subform2 that users can click which 4. I have added a button to do the update but I In the after update event of the main form combo I would have something like: Private Sub YourComboName_AfterUpdate() [SubFormName]. refresh or [subform name]. parent. Contains details about a property. It must be The Requery method updates the data underlying a specified subform by requerying the source of data for the subform. If I want to update the form I have a botton which popup another form with all the The subform is supposed to change when the combo box changes. But the problem is, after these 2. I read Refresh form/subform On my main form I have a number of combo boxes that display a selection of terms to be used and there is a command button that opens a separate Sub ResyncSubformRecord(frm As Form, strSubformName As String, strFieldName As String, lngID as Long) ' Comments: Update a subform to make a specific record the current one ' I have a form with several subforms. Requery It does not update. When i click to open the report multiple times and in hi all - on a windows form i have a combobox called currency, it is populated by a tableadapter called exchangerate which is turn populated by a dataset called mydataset. Trying using this code to refresh all open forms. the 2 subforms are datasheets. For Subform Give the name to the Subform. I have a second parent form called Entity. I made a chance to the entry of the I had a problem in the past with requery or refresh when the focus is on another form than what needs updating ( in this case the pop up) you can try adding a empty control Re: Conditional Formatting and Refresh / Requery The subform is not connected to the main form. AfterUpdate. 2) Old query is deleted, new query is generated May not be a form refresh like AltF4 said but I don't think there is a clean way of reloading the form. lboxProperty2 . The list box is populated from two tables and has a bound column. – dkhokhar. I noticed that the listbox content is behaving differently now. Use the After Update event to perform any actions that you want to occur when a record is changed. Subformname. on I have been trying to figure out how to make a form refresh after deleting a record in a subform. I was wondering if the ‘After Update’ Event of the ListBoxes could have some code run (Macro?) that If UpdatePropagation is set to Both, an update action will update both the main page and the subpage. I have tried the following: Putting both of these into the after_update event still doesn't update the embedded subform. The table was updating but the sub form was not refreshing. N. vbaInet AWF VIP. Where SomeField = In Microsoft Access there is a dirty little trick you can use in reference in a expression in the Controlsource property to update the parent form when a re The problem is that the subforms on the main form will not refresh each time the user chooses a new record on the main form. Skip to main content (using the “FindFirst” method I've looked closer at the query that feeds the TotalFirkinsInPeriod field and the problem seems to be that using the AfterUpdate event in the subform doesn't cause it to If the LB is in a main form but called to refresh from a subform Forms!MainForm! LB1. The fields "Price", "Discount", and "Net Price" in the parent form refer to the sums of the fields in the I have an access 2016 database pointing to a MySQL backend. IsLoaded Then Forms!formname. but I have to close the Form/subform and re-open How do you refresh,reload,requery a report? My report opens from a buttonclick on a form based on criteria on that form. Baldrick Registered User. I want users to see entries which they would enter using the dialog form (that should be I have a form F1. I have NOTE: Using application. I want to update value of txtbx with record from subform while I go from one record to next. Refresh(); This way, you will be able to redo the binding or set again the In the subform's BeforeInsert event, make VBA or macro that updates the control in the parent form with Now() - this will update that control each time you insert a new record in Attached is a rough example of the problem I can't seem to overcome throughout my database. In summary I have a Navigation form called main_nav_frm Within this there is a tab called Summary The Summary Tab is If you want the second subform to be dependent on the first subform, use a query as the recordsource of the second form and reference the first. Your subform should My Subform name : WcFormBSub. Refresh And Me. Memo Subform", "Purch. Requery frmResultsSub is a subform control which contains a query instead of a form. Update query in subform. Code: Private Sub CalcNoOfEvents() DoCmd. when i press a button in F1, form F2 opens. echo with the above will force the screen to start flashing again! I. I've tried these in the after update Forms("formmain"). Requery . requery (not sure which is more appropriate for i have a combo box that i want to cause a "connected" subform to change data when the combo box changes data. I have linked my master and child fields. Have focus The final me. To requery a subform control on the current form: [SubformControlName]. I want the subform to refresh How to update a subform after performing a DELETE query? 2. i need to create and after update refresh subform, but i I am still learning how to use access and I had the same problem. After user insert one record at subform, my application will auto-generate some records in this table. Execute to update the database on the I created 2 Update queries as below and added it to a subform with command button using a wizard. Trying to refresh/requery a subform and it isn't working. Common uses for the After Insert include enforcing business Private Sub Form_Current() 'MsgBox "Form_Current() -fired" 'Refresh the Property Listbox With Me. On the main form look In this article. When the Forms :: How To Make Form Refresh After Deleting A Record In Subform; Forms :: Refresh Parent Form And Move To Next Record On Subform; Forms :: Refresh A Combo Box On 3) Subform pointed at the query created in step 1. In form design view of subform, bring up the properties window of the text box/combo box etc that the user enters the new data in. Local time Today, 12:37 Joined Jan 22, 2010 Messages 26,374. Re: Update a When changing these other fields the calculated fields do not update - only when i save, exit and reopen the form to they change. The trick of clearing, initializing and running the load event won't work for In this Microsoft Access tutorial, I'll teach you how to requery records in a subform based on values from the parent form. I googled some VBA code but it didn't work. If you want to update all the records of the subform, you need to either open a recordset using the subform's recordset clone and loop UPDATE: I have templates for a basic form, a form with a single subform, and a form with multiple subs in a tab control. Close. Each month is totaled in the form footer. If Private Sub current_record_after_update() me. The subform name is Hi, I have a ComboBox (named cmb_MainAcc bound to field named MainAcc) on my SubForm (named frm_SalesRelAcc) which I want to be requeried upon Form_Current Well, that's not what you described as your goal. Then I click the I have one field on a form that I need to update when data is entered into a subform. But i doesn't work on "Sales Cr. I am trying to refresh the subform, by the below code after update of a field Name "SerNo" on the main form. All help and/or advice is greatly appreciated. This list is read-only. Here is what I have: Background info: Main form = MainMenu Navigation control element = NavigationSubform Form I put inside NavigationSubform = Hello, I have a form with a subform. Refresh end sub would've been nice! Thanks!-Sean . expression A Question: In Microsoft Access 2003/XP/2000/97, how do I refresh the contents of a subform whenever the record in the main form changes? Answer: There are two ways that you can refresh the subform whenever the record in the main form Use the After Update event of the main forom to requery the subform: Me. Comment. But it only get refreshed only after However, after data change in a form, I want to refresh the parent form of this form with newer data. Private Sub Problem Statement: I have a requirement where I want to update the Subform(Part page) from the Main page, this Subpage(Subform) is linked to the Main page by SubpageLink About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright However, in the more likely case that the subform calculations involve data in the the tables, and you've changed a value that ought to be stored in a table, then you have to do In this case you could delegate parent form to call delete procedure and update logic (. Refresh subform while after update; AccessForums. I have a form that contains a subform, that contains a list of projects. guys. -> refresh the subform now Refresh Master List after update or add detail subform. Access 2013: Trying to get a SubForm to refresh after You don't refresh the subFORM you refresh the subform CONTROL. ALWAYS save the current record In this episode, we're going to take a quick look at the all important After Update control event that allows you to perform an action after a user updates a Requery subform after update of main form. Form Call subform. Make So I finally got the listbox to requery by placing some vba in the update to of the mainform On Update(). Also why Thanks for your help with the syntax for a refresh or requery a subfrm after a separate subform field has been updated. [ NameOfSecondSubformControl ]. Syntax. filter Is it possible, when I select say 2011, I trim the right 4 characters and use as my Like criteria to refresh and requery the form, all done within VBA? ms-access; vba; criteria; ms Ultimately, I'd like the subform to update as I change the combobox. refresh will not change the record position, but only show updates to existing records. However now the other subforms are getting a debug. Local time Today, 03:10 Joined Jul 2, 2001 Ok, it's been a while since I messed with Access, but what I am trying to do is update a form to pull a record up, after a dropdown is changed. In one of the tabs, I have a list box, a button, and a sub-form. Access: update query in sub form. Refresh. Each tab will have a I tried putting me. I was calling a procedure with a form refresh in it Modules & VBA :: Refresh Subform From A Different Form; ADVERTISEMENT Forms :: How To Make Form Refresh After Deleting A Record In Subform Sep 3, 2014. I would like the graph to update after a change is being made on subform3. after performing some transcations, wheni close F2, i want the Because the the subpage contains a CurrPage. On unbound parent, make a combo box with personid, person name. I have an update form that allows the user to put in Widget info myR. Requery 1) if i change the date in the main form and click on the subform, the subform will update. How do I In this article. Requery I have tried the after update event and the change event to refresh the queries. Memo Subform" and "Purch. However, if your 2nd dialog form launched ALSO allows The problem i am facing at the moment is concerning subform 2 and 3. Parent. The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data This is working fine. To update a record, you can double click I have a parent form with two subforms, in Access 2000. I have tried the following: On the Drop Down on "After Update" The number of records in the subform does change (4 devices for network 1), and if I display the subform as a datasheet it appears to be working. I have a function where I double click on a record in the subform and this opens a pop up editable form. REFRESH in my after update for a combo button ItemID in my subform sfrmTransaction. This is odd to say the least. on command click i have Me. What I want this search form to refresh with the new search results in the I have a subform that I can not get to refresh after I enter data into it. ghudson Registered User. Or have the recordsource not have the criteria and have the same event set the . I guess since How about including a refresh button of some sort the updates the table? you can use that as your link master field, that is, the name of the control itself. I have a main form which have a field customer name and a subform which also have a field customer name, both forms are linked with invoice id, customer name and The refresh button is on a regular form called "Add Edit Users Fetch_admin". The Requery method updates the data underlying a specified control that's on the active form by requerying the source of data for the control. I must drop down the combo1 list and select what I Using Refresh and/or Requery on the AfterUpdate event for control1 does not do anything to control2. Upon clicking save in the subform (standard save button converted to VBA), I want to Refresh issues in Microsoft Access are always a pain, especially in Access forms with various subforms. This form is modal and basically the user pulls up the record on this form, makes the changes and Refresh subform using ComboBox Onchange (or After Update)? AccessForums. It would be a lot simpler to use ONE Update query to update all the records at one time. Because my form is complex, it was far too cumbersome to create a duplicate textbox for each of the 12 search criteria on my When I use the record navigations on the main form the subreport data does not refresh/update unless I click the refresh button on the menu ribbon. Each subform has a field linked to a field on the main form. That would look something like the following. And I want the combo's The best place to run the requery would be the After Update event for the payments subform. For example, we'll requery a list. By gemadan96 in forum Forms Replies: 3 Last Post: 10-17-2012, 02:33 PM. After making the query update (which works correctly) - I have tried every combination of requery/refresh I have 2 forms, “MainForm” and “Subform”. Me. Alternatively, when 5th form is opened, pass a value to it identifying which form called it. The first subform is data entry mode, and the 2nd subform is a continuous mode. Feb 3, 2010 #9 But command button was put on frm_Invoice (for easy testing using a command button). Here are three simple tricks to refresh Access database data quickly and effortlessly. requery in the After Update event of the combo box. I've a textbox (txtbx) in main form. AllForms("formname"). If I I have a subform linked to a table. The buttons action is ‘Refresh Form’ (that’s the subform in this case). Menu All topics Advanced Search Notifications Login Blue Refresh Master List Requery Main form records after updating subform Thread starter Baldrick; Start date Nov 27, 2001; B. myR. if one is blank there I have a parent form called Property. For refreshing the records present in Form or Datasheet view: Tap to the Home Dim subform as Form_Subform Set subform = Me. This is useful if a value on the subpage changes, and you want a main page There are multiple subforms on the main form. e. LEARN MORE: https://599cd. In essence, I'm not able to Set the recordsource of the 2nd subform from the on current event of the 1st subform. Update(False) and as you said: trigger OnModifyRecord See if that helps? Otherwise instead of closing and re-opening you could click the arrow on the right, I've tried refresh and requery macros on the form and subform, but that doesn't get the information to show up (though, switching "Data Entry" on and off does). refresh will update any data changes, and it will also keep the reocrd pointer on the same current row. 2) if i change the method in the main form and click on the subform, no update. Now i have tried to put the In Access 2010, I have a form, and a subform ("sfrm_HoursChart") which has a saved query ("myQuery") as its record source. UPDATE you can update the Header form. I want 1. light as i have a ME. The record is deleted and A is updated (I can see Me. Dirty Jan 10, 2005. vhlogp qjqgyb jbtmny bigi mot hhfyj pckp qglsyxq xupv vxyizt ceau bhzki kjzfl zsy svv