Re: Add multiple fields in a form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Phil,
I fully understand Paragrapgh 2. I'm clueleess on Paga. 1. The issue is
the form that prints out for the mechanic needs to have both the english and
spanish names and description because we don't know who will be working on
it. So and engilish person might fill it out and a spanish guy works on it
or visa versa.

Second issue, If the mechanic inputs p/n abc123 on the form I want want the
associated description of the part and the price to automaticlly be inputed
on the form.

Thanks, Dan - Virginia

"Philip Herlihy" wrote:

Dan wrote:
I am building a program for repair orders in 2007. I am dealing with both
english and spanish speaking employees. I have one field with the english
name for a piece of equipment and another field with the spanish name. I can
do a lookup box from another table that shows both fields so either employee
can choose the correct piece of equip. The issue is when they choose one
from the drop down box only the english name shows up and either a english or
spanish guy may work on the equip. so both need to show up. Also on the same
note when the mechanic fills out the repair order he looks up the part form a
drop down box and I would like the description (same issue both in english
and spanish) and price to be put up on the work order w/o having to go to
each field and looking it up.



My solution to this would be to have an option group so that the user
can choose the preferred language, and have the RowSource properties of
the Combo boxes set to a query that references that checkbox, delivering
the text the user needs.

Of course, combo boxes can display more than one field - they routinely
have two fields, with the field width of one (the key field) set to 0.
If you add the Spanish field(s) to the RowSource and set column widths
to appropriate amounts, then both will appear together.

Phil, London

.

Relevant Pages