On the button click of Form B, I implemented the following code to update the recordsetclone on subform C:
Code:
Private Sub btnCopyClassPairQuestions_Click() On Error GoTo HandleError
mrowe
Last Activity: Oct 5 '07, 03:28 PM
Joined: Mar 20 '07
Location: Los Angeles
-
Thank you everyone for your help. I tried all your suggestions. Some of them worked a couple of times then stopped working. I'm not sure why. Finally, I scrapped the 'requery' approached and did the following.
On the button click of Form B, I implemented the following code to update the recordsetclone on subform C:
... -
Hi Mary,
Sorry for my slow response. I have been side-tracked from working on this for the last couple of days.
I placed the requery for Subform C at the end of the button click code on Form B after the new values are successfully inserted into the database.
I placed the requery of Form ACode:Forms![OutcomeQuestionsForm]![sbfOutcomeQuestionsSubform].Requery
...Code:Forms!CourseInfoForm.Requery
Leave a comment:
-
Mary,
Thank you for your help. I implemented the Requery changes that you suggested. The first test that I ran worked, but every subsequent test I ran the requery did not show up until I manually closed and reopened the window. I don't get it.
Do you think this is related to ADO? ...Or do you think it is something else? I am curious to hear your thought.
Sincerely,
MarkLeave a comment:
-
Try looking at the following post:
http://www.thescripts. com/forum/showthread.php? p=2449139#post2 449139
I believe you are having the exact same problem that someone else helped me solved.
MarkLeave a comment:
-
Form & Subform Requery Problem - ADO Related?
I am using Access 2003. (I am also using ADO in the vast majority of my code. I recently read a post that indicated that ADO is not all that is was initially cracked up to be. In the back of my mind I am wonder if this is causing my problem, but I don’t want to go through the work to convert to DAO unless I know it is truly in my best interest.)
I am having problems getting a requery to show up consistently on a couple of forms.... -
DenBurt,
Thank you for you help. I had to play with it a little bit to get it to work, but it works and I am happy.
Because I am using ADO, I received a datatype error on the declaration of the recordset. So, I included ‘Microsoft DAO 3.6 Object Library’ in my references and changed the declaration to:
Dim rs As DAO.Recordset
Then I received Run-time Error 320 – ‘Update or CancelUpdate...Leave a comment:
-
Loop through checkboxes using ADO – Access 2003
I am working on a form in an Access 2003 database (using ADO). The detail section of my form has as checkbox named ‘Select’ that occurs once for each row of data. I have placed another checkbox in the header of the form named ‘SelectAll’. When ‘SelectAll’ is modified, I want to modify every occurrence of the ‘Select’ checkbox in the detail section. I looked through several posts and have played around with the code, but I have...
No activity results to display
Leave a comment: