How to do this?

[Guest]

I have a used car database. I have a combo box for body stytle (truck, van,
car, suv), and a combo box for KOV (P, T). Vans, cars, suvs are P (passenger
vehicle), Trucks are T (Trucks).

If I select the truck from the body stytle, i then go to next field select
T, if I select car, i then go to next field select P, could I set up a easy
way like when I select truck, the next field will automatic select T for me,
this way will save me times and help user speed up and less mistake, many
thanks.

 

[tina]

if trucks, vans, cars, and suvs, are *always* P, and trucks are *always* T,
then you don't need to enter that data in your used car data table at all.
simply add a column to the table that holds the body style values, and enter
the KOV value for each body style. you can easily link the data table to the
body style table in a query, so that the KOV values for each data record are
available to you as needed.

hth

 

[Guest]

Hi, Tina, thank you for replying and sorry i don't get it.

 

[tina]

are trucks, vans, cars, and suvs *always* P? and are trucks *always* T? and
in your UsedCars table you have a field to store the body style value and
another field to store the KOV value, correct? and on your form, you have a
combo box control for body style, correct? what are the settings for the
RowSourceType and RowSource properties of the combo box control?