Very easy to do. Easiest way is to have a combo box (cboEmployee) with three
fields - Employee #, name and address. Set the width of the second and third
columns to 0 to hide the contents. In the after Update event for the combo
box put the following code:
If Nz(Me.cboEmployee,0) <> 0 Then
Me.txtName = cboEmployee.Column(1)
Me.txtAddress = cboEmployee.Column(2)
End If
Guy Harley
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of fsctke612
Sent: Wednesday, 21 December 2005 8:09 AM
To: [email protected]
Subject: [ms_access] Populating a Form
Is it possible to automatically populate a form by inserting one piece
of information. As example would be using an employee # and when it
is entered on the form the Employee Name and Address would
automatically populate.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
