Double Click Event, unexpected action

kirkm

Registered User.
Local time
Today, 21:15
Joined
Oct 30, 2008
Messages
1,257
I'm using Access 2007 for the first time. converting something from an earlier VBA

I expected the Form double click event to run Private Sub [fieldname]_DblClick(Cancel As Integer) where Cancel = True would execute some code (independently of the Form)

This is working, but in addition if two forms are 'in view' it switches display to the other Form.

By 'in view' I mean both are in continuous sheet format with 2 tabs are showing above the first row. The 'active' tab is orange and the other blue, and you can toggle
between them.

Is this expected behaviour, or have I got something wonky? If it is normal can I override it so the Form does not change ?

Thanks...
 
You've quoted things that belong to VBA, but posted under Macro.
Your VBA-quote is ambiguous too, because it would never work as quoted.

To avoid more confusion strip your db to bare essentials to illustrate the issue, post it here with instructions how to recreate the issue.
 
Ok. Sigh, with all respect... VBA/Macro = same thing. I didn't include any code and if my description can't be understood, I'll go somehwhere else. I'd really prefer to learn something and not get into semantics.
 
VBA and Macro is the same i Outlook, Excel and Word.

In Access a macro is an animal totally unrelated to VBA. Sigh ... touchy besserwissers are a pain indeed. Bye.
 
Well I did explain this was coming from a earlier version of VBA. If anyone would like to help, I've found now this only occurs if the command "Stop" is executed. I've gotten used to that to allow stepping through stuff.
 

Users who are viewing this thread

Back
Top Bottom