Automatically Update Field

[Karl]

Hello,
I have a form where employees enter their timesheets.

Currently, the form has three fields project code (3 digit #), work code,
hours, and comments.

So when employees are entering their time they enter a 3 or 4 digit code
that describes what project they are working on. This code is found in a
table that also has the project name in the table. I.e the code for a project
is 707 while its name is Winter Survey.

As a quality control measure I would like to add the project name to the
form so that when an employee enters the code the associated name pops up in
the project name field. This would help employees to make sure they enterred
the right project code.

I should also note not every project code has a name associated with it, so
in these cases I just want to project name field to remain blank.

Any suggestions on how to do this?

Thanks in advance,

 

[Rick Brandt]

Hello,
I have a form where employees enter their timesheets.

Currently, the form has three fields project code (3 digit #), work
code, hours, and comments.

So when employees are entering their time they enter a 3 or 4 digit
code that describes what project they are working on. This code is
found in a table that also has the project name in the table. I.e the
code for a project is 707 while its name is Winter Survey.

As a quality control measure I would like to add the project name to
the form so that when an employee enters the code the associated name
pops up in the project name field. This would help employees to make
sure they enterred the right project code.

I should also note not every project code has a name associated with
it, so in these cases I just want to project name field to remain
blank.

Any suggestions on how to do this?

Thanks in advance,

Use a ComboBox instead of a TextBox and have the ComboBox store the number
while displaying the name. If you set LimitToList to Yes then they will be
forced to enter a proper value.

 

[Destin Richter]

Karl, it'd be easier for me to do this and fire it back to you. Can you send
a database with just the form and underlying tables/queries in question? You
need to create a control that references the correct column of the table that
has the project code and name in it.

Destin
(e-mail address removed)