A Very Hard Problem.. Need Description Box

[Nikelo11th]

hi there........

my problem this time is that i have a form which is linked to a database..... so when u update the form, the database will be updated as well.

on my form, i have a feild called pizza ordered....... u basically type in what pizza u want......... my problem is that i want a seperate box linked to this "pizza ordered" field. so when u type in a pizza..... a description will come up....... so if i type in "chicken hot" as the pizza..... i want "chicken with peppers....." to come up in the box...... and when i change it to "magarita", then the description on the seperate box changes to "cheese with tomato...." etc.......

u know what i mean.........
i tried using sub forms to do this after creating a seperate table for all the pizzas and description.... but i got stuck..........
if anyone has any idea.......... PLZZZZZZZZ HELP>>>>>
i would be so grateful to u.... thanks.........

 

[Nikelo11th]

oh yeh......

1 more thing

by database I mean TABLES.


and I DON'T TYPE in the pizza I want. It is chosen from a lookup wizard (i.e. a combo box).

So any1 how knows how to solve this problem, plz help!

Many thanks again!

 

[Mile-O]

Start by looking up the DLookup function in the Access help.

 

[Mile-O]

No probs there, Pat.

As you were...