im wondering if I can do something like this...... I have a text box called FileNo. Im wondering if I can use an on enter event so when the user enters a file number in the FileNo textbox and clicks enter it will display the result of the dlookup statement below in the txtForwarder text box. I set up this code which isn't displaying the result..... so not sure where to go from here. My program is working from beginning to end but if I could remove some of the manual work for the user using this method or something similar it would save them a lot of time. The dlookup statement itself does give me the desired result just not from the fileNo textbox so the dlookup statement itself is not why this code isn't working.
Private Sub FileNo_Enter()
Me.txtForwarder = DLookup("[FORWRD_NAME]", "File_No", "[FILE_NO] =
Form![FileNo]")
End Sub
Private Sub FileNo_Enter()
Me.txtForwarder = DLookup("[FORWRD_NAME]", "File_No", "[FILE_NO] =
Form![FileNo]")
End Sub