Can't step through macros

Gavx

Registered User.
Local time
Tomorrow, 03:57
Joined
Mar 8, 2014
Messages
155
I have some code behind an access db.

For example: in VB editor I have some code that looks like this;

Private Sub chkBusArrival_AfterUpdate()
'Add BusArrival to Product table
If chkBusArrival = True Then
AddProduct "Bus Arrival"
Else
DeleteProduct "Bus Arrival"
End If
End Sub

If I put the cursor in the first statement "Private Sub chkBusArrival_AfterUpdate()" and press F5 it displays a Macro dialogue box which should list all the macros - for which VB code has been written. But there is none.
And then I should be able to step through the code using the F8 button but cannot do this.

What could be wrong?

thanks

I might add the F5 and F8 key work perfectly in the Northwinds db
 
Last edited:
Try placing the cursor on a line of executable code.

I don't know what version you are using but I would suggest that you stick to VBA and forget Macros.
 

Users who are viewing this thread

Back
Top Bottom