Requery Not Working According to Plan

  • Thread starter Thread starter Commish
  • Start date Start date
C

Commish

Greetings, right now, I am trying to use a Requery to update certain
data on my "DraftTracker_H".

In the last field that I add data to, I have an Event Procedure using
AfterUpdate


Private Sub HCRLTeam_AfterUpdate()

DoCmd.Requery "frm11_DraftTracker_H"

End Sub

It's not working, I get "Runtime error '2109': There is no field named
'frm11_DraftTracker_H' in the current record.

If I want the requery to run after I finish updating a few fields in a
records, which event should I be using?
 
I don't think it's a problem with the event.
IIRC DoCmd.Requery expects a control name as a parameter.
Try Forms!frm11_DraftTracker_H.Requery instead.

HTH
Jon
Click to expand...

Jon, Thanks for your help, I used the following VB:

Private Sub Fielding_Slot_AfterUpdate()

Forms!frm11_DraftTracker_H.Requery

End Sub

And got back this error:

Run-Time-Error '2450'

Microsoft Access can't find the form 'frm11_DraftTracker_H' reffered
to in a macro expression or Visual Basic Code.

Does this need to be in a specific event? Or would I be better off if
I put this on a button?
 
Jon, Thanks for your help, I used the following VB:

Private Sub Fielding_Slot_AfterUpdate()

Forms!frm11_DraftTracker_H.Requery

End Sub

And got back this error:

Run-Time-Error '2450'

Microsoft Access can't find the form 'frm11_DraftTracker_H' reffered
to in a macro expression or Visual Basic Code.

Does this need to be in a specific event? Or would I be better off if
I put this on a button?
Click to expand...

The Forms collection contains only OPEN forms. Is there a form named
frm11_DraftTracker_H currently open at the time this code executes?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Yes, it is open the field that I used the AfterUpdate event on is on
that form.
Click to expand...

I'm wondering if it's an underscore vs. blank issue. Is the Name property of
the form in fact "frm11_DraftTracker_H" or is it perhaps "frm11 DraftTracker
H"? Access will sometimes replace blanks with underscores but they're not the
same.

Failing that, I'm left to speculate that you may have some VBA corruption. Has
the database been compacted? Decompiled?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
I'm wondering if it's an underscore vs. blank issue. Is the Name propertyof
the form in fact "frm11_DraftTracker_H" or is it perhaps "frm11 DraftTracker
H"? Access will sometimes replace blanks with underscores but they're notthe
same.

Failing that, I'm left to speculate that you may have some VBA corruption.. Has
the database been compacted? Decompiled?
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

Jon, First of all - Thanks for all your help so far.

Yes, I use underscores _ all the time.

I compacted and repaired the database a few days ago - should it be
redone? Or should I have not done that? Decompiled? I didn't even
know that option existed, so, I wouldn't have done that....
 
I'm wondering if it's an underscore vs. blank issue. Is the Name propertyof
the form in fact "frm11_DraftTracker_H" or is it perhaps "frm11 DraftTracker
H"? Access will sometimes replace blanks with underscores but they're notthe
same.

Failing that, I'm left to speculate that you may have some VBA corruption.. Has
the database been compacted? Decompiled?
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

If the form - "frm11_DraftTracker_H" - is in a tab control on a form,
do I need to specify its location and path? That form is on a tab on
the form named "frm11_Main" - how would that be specifically addressed?
 
If the form - "frm11_DraftTracker_H" - is in a tab control on a form,
do I need to specify its location and path? That form is on a tab on
the form named "frm11_Main" - how would that be specifically addressed?
Click to expand...

The tab control is irrelevant - but the fact that it is a Subform is very
relevant! A Form in a Subform control must be referenced via its mainform, and
the name of the Subform control on that mainfor (which may or may not be the
same as the name of the form contained within that subform control): try

Forms!frm11_Main!frm11_DraftTracker_H.Form.Requery

Forms refers to the Forms collection; frm11_Main to one of the forms within
that collection; frm11_DraftTracker_H to a member of that form's Controls
collection, in this case it happens to be a Subform control rather than a
textbox or combo or some other control; .Form refers to the Form property of
that Subform control, i.e. the SourceObject form loaded into the blank box of
the Subform control. That is the object which needs to be requeried.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
The tab control is irrelevant - but the fact that it is a Subform is very
relevant! A Form in a Subform control must be referenced via its mainform, and
the name of the Subform control on that mainfor (which may or may not be the
same as the name of the form contained within that subform control): try

Forms!frm11_Main!frm11_DraftTracker_H.Form.Requery

Forms refers to the Forms collection; frm11_Main to one of the forms within
that collection; frm11_DraftTracker_H to a member of that form's Controls
collection, in this case it happens to be a Subform control rather than a
textbox or combo or some other control; .Form refers to the Form propertyof
that Subform control, i.e. the SourceObject form loaded into the blank box of
the Subform control. That is the object which needs to be requeried.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.
Click to expand...


Jon, Thanks again for the help. After copying that line into my VBA:

Private Sub Fielding_Slot_AfterUpdate()

Forms!frm11_Main!frm11_DraftTracker_H.Form.Requery

End Sub
----------------------------------------
I still get a runtime error:

Run-Time-Error '2465'

Microsoft Access can't find the field 'frm11_DraftTracker_H' refferred
to in your expression.

Thoughts?
 
I still get a runtime error:

Run-Time-Error '2465'

Microsoft Access can't find the field 'frm11_DraftTracker_H' refferred
to in your expression.

Thoughts?
Click to expand...

Just that it's possible that the name of the Form within the Subform control
is 'frm11_DraftTracker_H' but the Name property *OF THE SUBFORM CONTROL* is
something else.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top