Requery Controls When Data Changes On Another Form
Jan 29, 2007
I have a listbox with a record in it for every record that is entered on another form. To add a new record, you press the button Add New which I made. That takes you to another form, you can enter a new record and close that form.
I then want the listbox to requery and show the new record. I have tried requering the listbox on close of the other form, I have also tried doing it on the original form's Got Focus event. None of this works.
chris
View Replies
ADVERTISEMENT
Jul 21, 2013
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.
View 5 Replies
View Related
Jan 10, 2013
I have a form with several controls. Among them are 3 in particular:
Vendor Price - Unit cost with no tax
Unit Price - Vendor Price w/tax
Old Price
What I am trying to accomplish is a way to track what previous costs were by having the Old Cost control populate with the Unit Price controls value when there is a change to either VP or UP either due to new cost or new tax rates.I found a bit of code online but was not able to get it to work for me...probably because I haven't a clue of how to structure it for my needs.
View 2 Replies
View Related
Dec 12, 2014
So I am creating a Complaint Tracking Database with Access 2013. In my 'complaint entry form' I have added to ability to "Open" and "Close" the complaint. While the complaint is open the user is able to enter/edit data in the complaint (new or old). When the complaint is "Closed" (done so with a button on the form that prompts the user to enter a date of their choice) the user should not be able to enter/edit data in the given complaint. In my original thinking, I placed checks on various events (on load, after update, on click) that checked to see if the current complaint had a date in the "Close date" field.
If the close date field was null then that meant that the complaint was open and the the controls would NOT be locked. If the close date field was NOT null (i.e. a date was present) then the complaint was closed and the main form fields were locked but the data was still viewable and unless they "re-opened" the complaint they could not change the data.
Now, in the complaint entry form, I have a subform that acts as a action tracker that is used by the user to keep track of the actions taken on the complaint (i.e. they requested documentation from such and such on this date..etc). My problem through all of this is upon closing the complaint and locking the main form controls, my subforms data just vanishes! At first I figured the problem might be with the linking of master and child fields, so I made sure that I left the ID in the main form unlocked when I loop through my controls during the locking process. This did not solve my problem. Code below:
Private Sub Form_Load()
Dim ctl As Control
If Not IsNull(Me.close_date) Then
Me.FormHeader.Visible = True
Me.btnClosed.Enabled = False
Me.btnOpen.Enabled = True
For Each ctl In Me.Controls
[Code] .....
View 3 Replies
View Related
Jul 24, 2013
I have a report that tracks scores for our employees. From the report, you can click a button to add a new score in a form or edit an existing score(frmscoretracker). On this form there are two subforms, in a tabbed control to track additional information about the score; what areas were marked down(Trends), and was it a failing score(AutoFail).
When this form opens I have it programmed to only show the subform if there is data in it. The goal being, if I am adding a new score and there is no existing trends or Autofails for this new record, neither subforms will show - I will add an after update even to show either trends or autofail depending on the score recorded. Also, if someone chooses to edit the score, whatever subform with data, will show as well.
When someone clicks to add a new score, opening this main form to a new record, both of the tabs show. However, if the form opens to an existing record, the appropriate tab shows. Here is the code
Code:
Private Sub Form_Open(Cancel As Integer)
'If the subform has a record, the tab is visible, if not, the tab is not visible
If Me.frmtrends.Form.Recordset.RecordCount > 0 Or IsNull(Me.Trends) Then
Me.Trends.Visible = True
Me.TabCtl33.Visible = True
Else
Me.Trends.Visible = False
End If
[code]...
Both tabs are set as not visible in the default settings. Is there something in this code that is triggering then to be visible when there is no record in the main form?
View 4 Replies
View Related
Mar 17, 2013
I have a Dynamic Search form, which I use to search for client, on the double click it takes me to the client, at which point I have the Forms Visible set to False.
When I click on a button to open that Form, the Visible turns back to True, however it shows my last search results, how do I clear it so that when I call it back up it is ready to search again, and my focus is set to the SearchFor box.
View 3 Replies
View Related
Sep 19, 2014
I have a form (frmTimecardsDataEntry3*) that needs to requery combo boxes to narrow down the selections offered in the dropdown of each combo box.
It is a data entry form. I.e. Dataentry is set to yes.
The ClientName combo box has an after update event which requeries the matter combo box, so that the MatterName combo box dropdown only shows the matters relating to that client. This works just fine.
The MatterName combo box has an after update event which requeries the Rate combo box so that in the Rate combo box dropdown only the hourly charge rates relating to that matter are shown. That works too. So far so good.
I then tried adding another after update event to the MatterName combo box, so that another combo box, Application, was requeried too, so with the Private Sub it looked like:
Rate.Requery
Application.Requery
But this resulted in the error in the title to this post and the debugger highlighted in red the word Requery in the phrase Application.Requery.
I thought maybe Access does not allow two requeries resulting from one after update event, so instead I took Application.Requery out and placed it as an after update event in another combo box which did not have any other after update events to run.
However, this resulted in the same error.So the error appears to have something to do with trying to requery the Application combo box but I cannot see what is causing the error.
The Application combo box SQL is:
SELECT Applications.ApplicationID, [ApplicationDate] & " " & [ApplicationName] AS ApplicationDisplay, Applications.ApplicationDate, Applications.ApplicationName, Applications.MatterName
FROM Applications
WHERE (((Applications.MatterName)=[Forms]![frmTimecardsDataEntry3*]![MatterName]))
ORDER BY Applications.ApplicationDate, Applications.ApplicationName;
This is the same arrangement of SQL that I am using on the other requeried combo boxes that work. When I take the WHERE statement out of the Application SQL and run it the query returns all of the applications.
I am not sure what the error code is trying to tell me about the attempt to requery the Application combo box.
I have a yes/no box in the form and when the firm is first opened it has a small square dot in it, but as soon as any data is entered in the form the dot clears and leaves the usual empty tick box that you would expect to see.
Also, another possible symptom is that I had another version of this form previously working quite well except that when I did several data entries all at once, so I had several forms filled in with different data (before refreshing and thus entering the data in the table), when I scrolled between the forms I kept losing the MatterName data when I scrolled back, and then when I re-entered the ClientName data the correct MatterName data returned without me having to use the dropdown to select it.
I have had an earlier simpler version of this form working for some time, with ClientName requerying MatterName and MatterName requerying Rate, and I am using the same SQL structures in the new form but getting the error in the title to this post and the other isues just described.
View 2 Replies
View Related
Mar 31, 2008
i have a data access page, which as a querry in it.
When i set dataentry true, none of the recrods are visible.
but, when i set dataentry false all the records are visible, here i have to change a value (ex; change a value in drop down ) which should get saved into the data base,
Please help.
View 2 Replies
View Related
Jan 29, 2008
Hi all.
I apologise if this has been a thread in the past but I couldn't find it.
What I have on my form is a dropdown which pulls data from a table (the table being durations of time in words, ie: One and a half days, Three days, etc.,) and I have just added a column that has the same durations in numerical form (ie: 1.50, 3.00, etc.,).
When the user is entering job data and selecting how long the job will take, the 'words' will be selected in the dropdown list and appear on the form and, subsequently be used on job sheets.
What I need is numerical value to go into a Text Box next to the dropdown and this is proving difficult for me to work out how it can be done.
Can it actually be done?
Thanks for any help.
Martin
View 5 Replies
View Related
Aug 26, 2014
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.
View 3 Replies
View Related
Aug 19, 2013
I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
View 2 Replies
View Related
Jul 1, 2015
Table name :TblMain
Field 1 : Bkg_Number (text)
field 2 : Container no (text)
Field 3 : Size (text)
Field 4 : Weight (number)
Table Name : TblBooking
Field 1 : Bkg_NUmber(text)
Field 2 : Customer (text)
field 3 : Vessel (text)
Field 4 : Voyage (text)
field 5 : Ttlcntrs (number)
First feeding data in the Tblbooking and creating a booking number. In the same time enters Total containers (ttlcntrs) for the booking. Then, importing some data to Tblmain by using Excel. Booking number is one of the columns importing. My question is, if number of records in the excel file, exceeds the number of total containers (Ttlcntrs) defined in the Booking table, error msg should be given and stop the import process.
View 1 Replies
View Related
Jun 20, 2014
I've got some forms that I've set to lock controls based on an added tag. I have a loop that goes through the entire form and disables (controlname.enabled = false) or locks (controlname.locked =true) all the controls with that tag.
This appears to work fine when the form is on a blank record but when an existing record is opened, the controls that have data in them are no longer locked or disabled (empty controls are still locked). Is there an explanation for this behavior? I don't want to disable the entire form because there are controls that I want the user to be able to always access. I started by just disabling them, then when I noticed the problem I tried locking them instead but it happens with both. Is there another property I can try that will really lock them if they have data in them or not?
View 1 Replies
View Related
Jul 19, 2005
Can someone please check this code for me, I just need to make sure that what I am doing is correct!
I am trying to requery a form from another form:
[Forms]![Form1].[Text1].Requery
View 4 Replies
View Related
Apr 3, 2006
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.
Thanks for your help.
Art
View 1 Replies
View Related
Jun 2, 2005
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?
View 2 Replies
View Related
Oct 6, 2005
Hi,
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.
Thanks...PH
View 10 Replies
View Related
Nov 3, 2005
i tried this
DoCmd.Requery ([frmpcinfo.AssignedBadge])
somehow that doesnt work.
all i wana do is requery a combo (assignedbadge) on the form (frmpcinfo) when the pop up form unloads/.
please assist :confused:
View 1 Replies
View Related
Apr 30, 2006
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?
Thanks in advance
Hiten
View 2 Replies
View Related
Apr 24, 2008
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 am trying this with no success
MainForm.SubFormName.Requery
MainForm.SubFormName.Refresh
What am I doing wrong????
THanks
View 2 Replies
View Related
Jan 20, 2008
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?
View 1 Replies
View Related
May 1, 2012
I'm a complete novice to vba. I'm trying to automatically requery a form after executing a macro. I know there's a lot out there about requery, but I can't seem to get it to work. It's clear that the best way to do this, is to code it in vba.
I have a form called "Formulier_afspraak_nieuwe_patient" that I'm trying to requery from the converted macro Macro_toevoegen_nieuwe_patient()
View 5 Replies
View Related
Jul 18, 2015
How do you requery/refresh a form from within another form?
refresh formA from within formB in VBA?
View 14 Replies
View Related
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.
View 1 Replies
View Related
Feb 28, 2005
It's easiest if I take you through step by step. I open a form with a list of students and I have to enter the condtion for a Tutor Group (say I type in 13EN). The form then loads up with all students in 13EN. Then I have a 'Add Student' button which loads up a form with an indivudual students information qith a blank record. Then I press a 'Done' button which closes that form and requeries the Student List form.
My problem is when I requery the form I have to re-enter the condition for 'Tutor Group' i.e. I have to type it in again. Is there any way I can refresh the data from the conditions I have already entered (i.e. for the Tutor group, 13EN) without having to type it in again?
Thanks
View 2 Replies
View Related
Apr 18, 2005
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.
Any ideas?
Thanks!
View 3 Replies
View Related
