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
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: