Cannot requery combobox from another form (1 Viewer)

ColinH

Registered User.
Local time
Yesterday, 16:06
Joined
Dec 5, 2008
Messages
23
vbaInet, thanks for responding.
I don't understand your use of the term 'Event Box'.
I'm using Access2003. The code is run by clicking a button, so I go into design view on the form, highlight the button, display its properties, click the Event tab, then the 'On Click' event and next to [Event Procedure] I click the tiny button with three dots.
This opens the code module associated with that form in a separate Microsoft Visual Basic 6.5 editor window, and goes to the start of the sub in question.
 

vbaInet

AWF VIP
Local time
Today, 00:06
Joined
Jan 22, 2010
Messages
26,374
I was referring to the property sheet, the textbox of the event in the property sheet.

But I can see why anyway. You don't need the parentheses if you're calling a sub/function without the "Call" keyword. You only need the parentheses when you're calling the sub/function with the "Call" keyword AND the sub/function requires parameters.
 

ColinH

Registered User.
Local time
Yesterday, 16:06
Joined
Dec 5, 2008
Messages
23
Thanks, vbaInet.
Again, I wasn't aware of that subtle detail that I don't need parentheses if there are no parameters.

So much to remember!
 

vbaInet

AWF VIP
Local time
Today, 00:06
Joined
Jan 22, 2010
Messages
26,374
This is just one good example of error messages that don't help at all.
 

Users who are viewing this thread

Top Bottom