IF THEN Value - Please Help

[taylorsmith8]

I am not a DB expert by any means. That said, I need to do the following, in either the Query based on a table or the Form that is based on the Query, and could use some suggestions:

Field: Box Type (BB bankers box, BO box other, NB not box)
Field: L:
Field: W:


Field: H:

What I need to have happen is that if [Box Type]="BB" then [L:] populates with 15.5, [W:] with 12.5 and [H:] with 10.5

If [Box Type] is "BO" or "NB" then I need to be able to enter custom data

I am stumped. Seems like this should be easy, and maybe it is and I am just missing it. I tried the following in the Field section of each [L:], [W:] and {H:] : (for [L:])... =IIF([Box Type]="BB","15.5") and that worked for all of the Box Type BB records, but then I couldn't manually enter any data at all in any of the not BB records.

I would very much appreciate any help at all. My thanks.

[pbaldy]

Please don't post the same question more than once:

https://www.accessforums.net/access/...elp-13012.html