getting data from a bound control when form first loads

[L Melville]

Hi,

I need to get the data from a bound control on a form when the form loads,
but it appears that i cannot use the form load event to get the data as it
may be too early to try to access it. How can i get hold of this data as
soon as the form has loaded?

thanks
lee

 

[Van T. Dinh]

Not sure why you can't since the data is avail even in the Open Event. I
did a quick test using:

Private Sub Form_Load()
MsgBox Me.txtEmpID
End Sub

where txtEmpID is a Control on the Form and the MsgBox showed correct value.

 

[L Melville]

yes it does work, i just tried it on another form, i must of done something
wrong with the form i tried it on

thanks