Forms in access

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

I have a ID and a description in a table. How can I view automatically the
description as I enter the ID?
 
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
 
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
 
Back
Top