Forms :: Requery Form After Making Changes In Another Form
Sep 17, 2014
I have a form that shows a companies engagement with our company. If someone wants to edit the details of that company (address phone number etc...), they click the "edit" button, which then opens a form where edits can be performed.
After the edits are done, the user clicks a save and close button which runs docmd.runcommand acCmdSaveRecord, and returns to the companies engagement form.
When I return to the company engagement form, I would like to see the companies information reflect the changes that I just made. Currently, I can only do this by exiting the form and re-opening. I have tried using Me.Requery in the OnGotFocus, Activate and Current events to no avail.
I should mention that I have a company combo box with multiple columns that are used to display address, postal code, etc... in textboxes on the same form.
I am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.
- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP - My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).
Here's the code I have written:
Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k() If Case is a Readmission from WRCA IP to WRCA IP =true then Date of Current IP Admission.visible=true Else Date of Current IP Admission.visible=false
I need to requery a subform from a third form and can't seem to get it to work.
frmForm1 has frmAddress as a subform. The button cmdReviseAddress opens the form frmUpdateAddress where all of my validation work is done and the new record is added.
However, the new address is not being displayed in the subform.
If I use the command Forms![frmTest]![frmAddress].Requery it works fine.
The problem is that I want to be able to frmAddress on any form, and need to pass the name of the main form (in this case frmForm1) as a variable.
If lsTemp = "frmForm1", the statement Forms![lsTemp]![frmAddress].Requery (and every variation using brackets and quotes that I can think of) fails.
New to access...just build a form, in which there are combo boxes....cascading of boxes was done.
Now the problem is I want afterupdate function to get activated when user changes the value of one combo....for which I have created a code in code builder... see the code... I think I am making a mistake in writing the code to requery...
I have a main form "FrmTimesheetEdit" that I open in edit mode to review data in a query that uses two tables TblEmployee and TblTimeSheet. The TblEmployee has two fields called EmployeeID, and Employee. The Tbltimesheet table has a field "Weekendingdate" and "EmployeeID".Prior to loading the mainform I launch a form "frmEmployeeReportRange" that allows me to specify via combo box the Employee I am interested in and also the time periods I am interested in being "Beginningdate" and "EndingDate" These in turn are criteria for my query that supplies data to the main form "FrmTimesheetEdit" Everything seems to work ok.
However the first time I open the main form It open a form/window saying "Enter parameter Value" for EmployeeId, BeginningDate and Ending date respectively. Then the subform loads "frmEmployeeReportRange" which allows me to specify Employee plus beginning and ending dates. I select Employee from the combo box say "Emp1" and specify Beginning and Ending dates of 1-Jun-2013 and 30-Jun-2013. I then make the form invisible and the mainform opens up.I do this but get no records. If I close the main form "FrmTimesheetEdit" and reopen it the subform pops up as expected. It is preloaded with the data I entered the first time i.e. Emp1 plus 1-Jun-2013 and 30-Jun-13...If I leave the dates the same but select the next employee "Emp2" and them make the form invisible the mainform opens in edit mode as expected but with the records and dates specified for Emp1.
Bottom line it would appear that although the filter data is specified for the query that feeds the main form it is not requerying prior to opening the form. I have tried having the "frmEmployeeReportRange" launched as a VBA event on each of 'On Open' , 'On Load' and 'On Current' but no matter where I put it the results are the same in that the mainform is not requerying the data prior to opening.
I have a split form that was not made by wizard. On the form part I have a combobox that is unbound to the form data set. The combobox has a query row source that is based on the current row selected. I want the combobox to have an up-to-date result based on which row is selected.
If I set the combobox to requery in the form_current event then I get what I want. I don't want to put up with the little delay that is generated every time a user changes rows because of the requery, though. I only want the requery to happen when they use the drop-down menu.
I have the requery in the gotfocus event of the combobox on the form. I mostly get what I want this way, however if they select an item in the drop-down list, then choose a new record in the datasheet, then try to use the combobox again, the combobox is not refreshed (because it never lost focus?).
To get around this, I've tried to setfocus to something on the form in the on_current event, but access gives me an error: 'Access can't move focus to the control btn_Refresh'.How can I get the combo to requery only when users are about to use it?
frmTaskTracker -subfrmInbox (Datasheet View - based on a query)
frmUpdateInboxItem
subfrmInbox displays a summary of tasks on a task list. The user navigates to frmUpdateInboxItem from frmTaskTracker. After updating a record from frmUpdateInboxItem, it is possible that it the record in question will no longer meet the requirements to have it listed on subfrmInbox.
I have attempted to add code to the on close event of frmUpdateInboxItem to requery the sub form on frmTaskTracker but am not getting the syntax correct.
correct my code? Alternatively is there is a more correct way to do this, I'd be happy to learn it.
Code: Option Compare Database Private Sub cmdClose_Click() Me.[frmTasktracker]![subfrmInbox].Requery DoCmd.Close acForm, "frmUpdateInboxItem" End Sub
I have a form called Add New Delegation, i have combo box of Institution names on the main form and a subform for Agreements discussed. with a combo box called agreements. I successfully cascaded the combo boxes so that the agreements discussed on the subform are filtered by their respective institutions on the main form. However i am unable to refresh the list each time a new institution is selected as the Macro will not allow me to requery a control on the mainform from the subform..
I have a form (frmAddManifest) with a subform (subfrmManifestTransporters).
When creating a new record, I can enter data into frmAddManifest, but the subform doesn't update to link with the record - I presume it's because the record from the main form hasn't been completed yet.
Is there a way to requery the form and/or subform so it stays on the record I was working on, and link the subform properly?
hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.
I have got 3 forms, and at the time of running, I want to make one primarily one form to be showing up and the other 2 to be hidden or closed, and the primary form will have 2 buttons, and clickning respective buttons should be able to open another 2 respective forms.
At the moment am using, DoCmd.OpenForm "Form1", which works fine, but am confused in brining the form 1 only to be shown at the first most time.
I have a subform with continuous records. One of the fields in the recordset of the subform is a field named "Remarks". This field does not need to be visible on the continuous subform as it is rare that this field will have any entries.
I plan to apply conditional formatting on another field (IDcardNo) in the record line of the continuous subform so that when field "Remarks" contains any data it will show as a different format on the field IDcardNo.
I would like to make a small form appear when one points to the IDcardNo field with the different format, so that the data in the field "Remarks" pops up when one points to the field IDcardNo with altered format, showing that there is data in the field "Remarks".
I new to this form and to access and hope to find an answer to my problem.
I have 3 tables and 3 forms
Table 1 - Form 1 --- Psych Patients Table 2 - Form 2 --- Med patients. Table 3 - Form 3 --- Primary Doctors.
Each form has a combo box with a list of Primary Doctors. If doctor is not in the list then we have the option to enter new information via Pop up form (form 3). At close the Pop up form requerys the cbo box.
Is there a way to use Form 3 (pop-up form) to re-query both forms at the same time even if only one of the forms is open?
FYI, Table 1 and Table 2 contain different information and the only thing both table have in common is the primary doctors.
As of now my code in the pop Up is:
Private Sub Form3_Close () Form_Form1!cboPhy.Requery End Sub
Is the only alternative to create another form for the physicians and use it for Form 2?
I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.
I am new at Access and have a database that has 2 tables (Donors and Donations). My donations form's source is a query. I have a combo for the DonatorID on the Donations form. I have a On Not in List macro that opens the Donors form so they can enter the name of a new donor. This works great but when you close the Donor form and the focus goes back to the DonorID combo, the new donor isn't in the list. How can I requery this so the new donor that was added to the Donor table shows up in the combo? I played around and added another combo that had tab index 0 and then everything works but this aint the solution.
Is there a way I can requery a continuous form. Basically my form runs from a query. If when certain criteria become true I want that record to move to a different form, (working on another query) Basically I am saying is that if checkbox1 = true then I want to hide that record. Does that make sense?
I have scanned through the forum but have not found an answer for the above..
How do I do a requery only for the combo box of a particular record in a continuous form? To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all sub-sectors based on the value selected in the previous primary sector combo box.
When I do a requery using the following code,
Me.cboDACCode.Requery
all the records in the form get requeried.
All the field are bound field.
There was a similar post in the form but was not complete.
Silly query, think I am missing something obvious but I shall ask anyway.
I want to update certain lists in my form do the user can select from this list to update a field, so i click on a button and open a table, update a record and then close it to return to the form.
the List does not update unless I close the form and re-open it again.
Is there a property that automatically updates the list on exiting the query / table you are updating?
I have a main form....I click a button on this form and another form opens...an edit is made....(BOTH MUST BE OPEN) WHen I close this form I want to Refresh a List box on the Main form to reflect this edit.
I have created a split form that shows all records from the main table. On the split form (form1) I have a button that opens a second form (form2) to add records. On form2 I created a button to save the records and that works fine, but form1 does not show the new record after the save button is clicked.
I am attempting to use requery to show the new record but I am not having any luck. Right now, form1 only shows the update if I switch to detail view and then back to form view. Maybe I am not doing something right, I am new to using MS Access and VBA. I have tried using the requery with an onclick on the save button and I also tried using requery on form1 in the ongotfocus event. I am using a macro to do the requery, and I have left the argument blank.
Can someone please point me in the right direction to fix this?
