Requerying Subform Issues!!!
The combo box operates properly. I see all my data in the combo box. My issue is when I select data in my combobox, lets say the number 99, nothing happens in my subform.
If I change records of my main form and come back to the previous record, the "99" is showing in the subform along with the other data I want.
I want the subform to change as soon as I select my data in my combobox. I wrote some code so when the combobox updates, it requerys the subform. But what happens, the subform requerys, and just the field that my combobox writes to updates, the other fields are blank.
Then, if I change main records and come back, the data is there. What am I missing?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I don't believe I have my forms are linked properly. My main form contains employee ID, this is a lookup field which is calling the employees table. When I enter the employee ID, all my other controls auto-populate. I then have a command button which opens my subform Issues. I have the employee id control in my issues form equalled to the employee ID in my Employee details form (master form). However, when I go to add new employees and I click the subform Issues, all the records are there, I would like to have a new record when there is no employee id equalled to the ID in the employees table.
The form and subform each have a DQRFileID field to link the records in a one to many relationship.
I was prompting for the client number (from the query in the recordsource) in the form and it displays the client info but not the subform issues that have been added.
Is there something I'm missing?
(Using Access 2007)
When I run the Loan Search query with Search populated, it filters and works correctly. When I try to have it requery automatically, it doesn't seem to.
I have tried every combination of
Forms![Navigation]![Loan Search Subform].Requery
Me![Loan Search subform].Form.Requery
that I can think of. Some throw error messages. but no requery occurs.
Has to be simple what did I forget
As I step through the first 3 records (Contract # 1) neither the Main form nor the Issue form changes. It only changes when I get to the 4th record (Contract # 2).
I was expecting the Issue subform would display a different issue as I stepped through the Main for records (4 records) but it just shows 1 of 3 records (displays only the first record in the subform) in the Issue subform for the all 3 records in the Main form so I am seeing the same information three times! OR I was expecting the Main form to display 1 of 2 records (only 2 contracts have Open Issues), then I would have to step through the Issue subform to see the Open Issues for that contract.
If I use a combo box in the Main form to filter what I see in the subform, are the results I am getting correct? I would prefer the Main form to show 1 of 2 records.
My first attempt was to assign the ID that was selected to a textbox on the main form, then automatically requery the second subform based on that value. I used this way on my search box. I'm sure there is a way to go directly from clicking the value to requerying the second subform, but I don't know it. If you do,
That being said even the indirect first attempt isn't working. It all has to do with the ".", "!", and ordering of this stuff. I'm not sure what . and ! mean. Cananyone explain them, It has to do something with Parent child, but beyond that I'm at a loss.
Me.[Collateral] = Acct_Reference_id
Me.[Navigation]![textbox] = Acct_Reference_id
I did find this very useful site [LINK]. It shows what code you can use depending on where you are and what you're doing. Even with that as a resource, I'm still at a loss.
Main Form: frmOfferCreate
Subform 1: frmVendorSelect
Subform 2: frmSku Select Activate
Subform 2 has a hidden button (cmdChangeVendor) (should only be visible if you use subform 1). When in subform 1, when I hit continue, it runs a macro that runs queries and opens subform 2. I want to set the property of the button in subform 2 to visible.
You can also access subform 2 from another location, so I can't use the On Load property.
In the macro I have:
Action = SetProperty with Control name = subform string, Property = Visible, Value = Yes
I have tried the following subform strings:
Is there any way to automate the process so that Access automatically goes back to the record that I was editing after requerying? I would imagine there is,