I'm guessing that you are using what is known as an autolookup query where
the table on the One side of a One to Many relationship is joined with the
table on the Many side of the relationship. Then as long as the join field
is added to the query from the Many table, when data is added to the join
field, the related fields from the One side are populated for you.
Take a look at the underlying query. Is the NAME field coming from one table
while everything else is coming from a different table (I have no idea what
kind of data you're entering on this form)? If so, just add the Hire Date
field to the query by dragging it from the Employee table. Then save the
query and then drag the field onto your form.
The other way this is commonly done is to use a combo box for looking up the
EmployeeID - by including other related fields in the combo boxes rowsource
query, you can easily add textboxes which use an expression to get their
values from the combo box using the Column Property.
One other thing - you should avoid having a field named *NAME*. *NAME* is
used extensively as a builtin property of most objects and this can lead to
runtime issues and anomalies when it is unclear what *NAME* is being
referenced. Generally speaking, it is better to use a prefix or suffix to
describe what kind of name it is, ie FirstName or LastName. Same thing goes
with Dates and other common keywords.
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
Hey guys,
I have a form where I key info every day. When i enter ID of an
employee, column NAME shows his name automatically. I want to include
one more column HIRE DATE. How do i make the form to show the hire
date automatically too, like it does with NAME?
Your help will be highly appreciated.
Thanks.
