Forms in access

[Joseph]

I have a ID and a description in a table. How can I view automatically the
description as I enter the ID?

 

[Damon Heron]

On an unbound form, put a textbox for the ID entry.
Add another textbox for the description.
In the afterupdate event of the first textbox, put this code:

me.your2ndtextbox= nz(dlookup("yourdescriptionfield","yourtable",
"yourtableID = " & [yourfirsttextbox]),"")

Damon

 

[Damon Heron]

Actually, this might work better:

Private Sub Text0_AfterUpdate()
If IsNumeric(Me.Text0) Then
Me.your2ndtextbox = DLookup("yourdescriptionfield","yourtable",
"yourtableID = " & [yourfirsttextbox])
End If
End Sub

I am assuming the ID field is a number, by the way....

Damon