I wanted to find out, if this can be done in access and would appreciate you help.

i have set up a form with 6 text boxs and appropriate lables too. i also created this query. now, what i wanted to do is when i click command, a query should run. and it based on label, it should input value in each text box.

for example, i have a query which prints out, description and amounts. i want each text box represent amounts based on description. so if i have auto parts as a lable, it should pick autoparts amounts 200 dollar in 1st text box. second text box, oil and it should represents so on.

will appreciate your help.

thanks

nix