Iif, After Update ???? how to have one field update another

G

Guest

I'm not sure how to do this exactly, but it seems like either Iif or After
Update someow might work.

I have two combo boxes on a form with values that I entered. The first one
is then entered into the Ad Size field. The second one is then added into
the Dimension field.

I'm thinking it would be easy for my reps if it could do the following:
if they entered FP in Adsize (for full page ad), then a 1 would show up in
the Dimension field. If they entered 1/2 H (for 1/2 page horizontal), then a
..5 would show up in the Dimension field. (in all there are about 10 options).

For reports, I need all the numeric dimensions to show up in the dimension
field. This is probably a simple question for access gurus, but it's got me
stumped.

Any help would be appreciated!!

Teri
 
S

Steve Schapel

Teri,

I would suggest you make a simple table with 2 fields (Adsize and
Dimension) and enter all 10 of your possible options in there. Then, on
your form, use this table as the Row Source of the Adsize combobox. The
table that the form is based on should *not* have a Dimension field. On
your form, and on your report, this value will be displayed by reference
to the little table I have suggested. There are various approaches you
could use, to get the corresponding dimension shown on the form, based
on the Adsize entered. This topic is discussed here...
http://accesstips.datamanagementsolutions.biz/lookup.mht
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top