We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Run Time Error 2450

schneider_ks
schneider_ks asked
on
Medium Priority
355 Views
Last Modified: 2013-11-28
I've got a data entry form: frm_Log with a combo box for clientID: ComboClientID and a combo box for Staff: ComboStaffSignature
When a new client or a new staff has to be entered, I've got a command buttons that open either frm_Client or frm_Clinicians
When those forms close, I want the respective combo box to update, and so have this code on the form close:
Private Sub Form_Close()
     Forms!frm_Log![ComboStaffSignature].Requery
End Sub
Private Sub Form_Close()
     Forms!frm_Log![ComboClientID].Requery
End Sub
but am getting the error code 2450 .....can't find the form 'frm_Log' referred to...but it does exist
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Is the Log form actually named "frm_Log", and is it open at the time? Your code would only work if those two conditions are True.

Also, are these combos on a SUBFORM?

FWIW, I use this syntax:

Forms("frm_Log").ComboStaffSignature.Requery

Either way will work, but as the Combo is part of the controls Collection, you really should refer to it with a Dot ( . ) instead of a Ban ( ! ).
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
I agree with Nelson regarding the NotInList, but it's quite common to open a form when this event is triggered ... often you don't simply add a single line of data to a new record, and you often need to allow the user to enter other data items.

Author

Commented:
Thanks!  I moved the code to the unload event, and it's working.  Sorry, but I didn't understand the rest of your comments.
CERTIFIED EXPERT

Commented:
You're welcome.  Glad to help.

The usual place records are added to a combobox is in the combobox not in list event. It has features designed to simplify the process.

Happy Computing!

Nelson
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.