|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 15th, 2009, 06:48 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Forms in access
I have a ID and a description in a table. How can I view automatically the
description as I enter the ID? 
|
|
#2
March 15th, 2009, 08:45 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Forms in access
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 "Joseph" wrote in message ... I have a ID and a description in a table. How can I view automatically the description as I enter the ID?
|
|
#3
March 15th, 2009, 08:57 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Forms in access
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
