Look-up values

[Dan]

I am using Access to track entries for a bibliography. Each bibliographical
citation is tracked on broad categories that are in French and English.

I am using a table to look-up values for the category lists. It has to be a
separate table for the data in some fields is too long to set-up within a
table strucuture. The table with the list is three columns: Index (numeric)
French Category, English Category.

I like to some how program the data entry in my form that once the English
category is chosen from the drop down list, the corresponding French value
pops up in an adjacent field automatically.

[pietlinden]

make the combobox in question 2 columns wide (or wider, if you include
the PK only), and then set the value of the French field to something
like:

cboCategory.Columns(2).Value

and refresh the textbox when the cboCategory changes. then hide the
columns you don't want to see.

[Dan]

I'm having problems sorting out your reply.

You write:
make the combobox in question 2 columns wide (or wider, if you include
the PK only),

DL: Are you suggesting that I do this in the Row Source of
DL: the original Table or in the Forms?

and then set the value of the French field to something
like:

cboCategory.Columns(2).Value
DL: I can't decipher the logic of this string. What does
DL: cbo mean? Can you give me something based on the fields
DL: I have? For the table in question with the categories
DL: they are: Index [number/Primary Key]; EN [English name];
DL: FR [corresponding French text string].

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!