Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / August 2006

Tip: Looking for answers? Try searching our database.

auto fill ins

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PR Kid - 01 Aug 2006 18:11 GMT
I have a master employee list with personal information. I want to make up
some forms that will auto fill in the fields when I input their Emp.ID
numbers. I am new to access please help in easy to understand format
Signature

Have a great day

jahoobob - 01 Aug 2006 18:49 GMT
If this is just a look up form or an employee information edit form, then
create the form based on your table or query.  Add a combo box to the top of
the form and choose the third option of the first wizard screen.  Complete
the wizard selecting the Employee ID as the bound field.  When you type or
select the employee Id in the combo the rest of the information will be
displayed.
If this is a form in which you are entering data that will not go into the
employee information table such as sales information, you don't want to sore
all the employee info in the table, only the ID.  In this case you will need
to create unbound fields on the form for the employee info.  You can then add
a combo based on the employee info table/query with all the pertinent fields
included in the combo source.  In the Afterupdate property of the combo box
place this code:
Me.NameofUnbound1 =Me.ComboBoxName.Column(1)
Me.NameofUnbound2 = Me.ComboBoxName.Column(2)
etc.
Columns in a combo start at 0 so that the second column in the combo is
Column(1).

>I have a master employee list with personal information. I want to make up
>some forms that will auto fill in the fields when I input their Emp.ID
>numbers. I am new to access please help in easy to understand format
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.