Printing Results

[Typ0]

I want to see what is going on in my program so I figure printing out a MsgBox is a good approach...

I have a textbox and this in the on change event:


Private Sub ID_Change()

MsgBox "This has been changed. "

End Sub

I see the textbox changing but nothing happening? Why?

 

[JHB]

The event is only got fired if you change the value in the control, and not when you only scroll through a recordset/table. For that you need the on current event.

 

[Typ0]

Thanks. It is a form bound directly to a table that scrolls through recordsets yes. And I don't see a on current event. File attached.

That brings up another question. I'd really like to be able to build one form and use it for multiple things (ie. one to update a record and one to create a new one). In a .NET app I'd just make a control and use it in different places...is there any way to use access like this? I'm kinda in a hurry but I'd like to understand this piece of my puzzle....

 

[Typ0]

I did just find the on current event of the form...which actually does something like I want it to do!