refreshing!

[red91]

I have a form with a box that uses the Dlookup function in it. The function works great. My only problem is that when you open the form the box does not display the look up value until you click on it, even if the input value for the function was previously entered. How can I make the values of these boxes show up when someone opens the form? Thanks!

 

[Opengrave]

Have you tried refreshing as part of the forms OPEN event procedure?

 

[red91]

Where do I do that? In the actual field on the form or through VBA code? If possible can it be done without the having to code in VBA? I really don't like writing VBA code! thanks!

 

[red91]

Uh???? I don't know if it's just my computer bieng slow or what, but I closed out of the database and opened it back up and all of the fields in the form that use Dlookup displayed the values automatically without having to click on them. Why would it show them and tnen not? I didn't change anything either.

 

[Opengrave]

Where do I do that? In the actual field on the form or through VBA code? If possible can it be done without the having to code in VBA? I really don't like writing VBA code! thanks!

Here is a cut-and paste. Go into the code window for the form and past this code:

Private Sub Form_Load()
	Me.Refresh
End Sub

I've never used DLookup so I'm not sure about the strange behavior.

 

[red91]

thanks!