I am just making the move from A2K to A2010 (or A2KX ?); missed out
all the intervening steps. Have been exploring it for a few days now.
Have sorted out a few things like finding the navigation pane instead
of the database window; although why I need to quit and restart the
database when I want to display or hide it is irritating!!

I may be posting a few questions as I get further on but for the
moment I have one about the double click event:

In a form I have many text boxes all with the same Double Click
action. In the properties of each textbox, against the On Double
Click event, I have =[viewEntry]. ViewEntry is a public sub in the
code module of that form.

This works perfectly well in A2K but gives an error in A2010:
"the expression On Dbl Click you entered as the event property setting
produced the following error: The object doesn't contain the
Automation object 'viewEntry'
* the expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]"

The help system seems to suggest that A2010 handles it the same as
before. Any advice would be welcome.

"Jim Devenish" <internet.shopping (AT) foobox (DOT) com> wrote

Convert the sub into a function. Then it's something that Access can
evaluate.

Hi Jim,

This is the way I typically use in events (A2003), no Function, no
‘=’:

Private Sub ThisField_DblClick(Cancel As Integer)
ViewEntry
End Sub


Imb.

On Feb 7, 6:25*pm, "Stuart McCall" <smcc... (AT) myunrealbox (DOT) com> wrote:
I was very hopeful with that suggestion but I still get the same
error. Any other ideas?

Jim Devenish wrote:
Wouldn't
=ViewEntry()
work instead of
=[ViewEntry]

On Feb 7, 8:06*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
Thanks, good idea. It works.

The syntax appears to have changed. They have also corrected the
earlier problem wherein the function was called three times for one
double click.