Form Help, Not sure how to attempt

[Jchristensen]

I am building a database with prices for different services.

Now for example i have a drop down box with "service 1, service 2, service 3" that can be selected.

Service 1 - $4
Service 2 - $8
Service 3 - $10

There are different prices attached to each service like down below. Now in my form, say that i change the "service 1" to "service 2". Now the prices are in different fields in the table.

So now my question is how will i get the prices to automatically change over? without them havnig to manually change the text box?

and if anyone wants a test DB to see what im talking about let me know and ill send one. This is really important and i need to get this solved asap. Any help possible would help greatly.

Thanks again,
Jon

 

[Banana]

If prices are bound to the services, they should be in single table. Bind your textbox to the same table's price column and it will be done automatically.

 

[Jchristensen]

Ok, i got this to change with the combobox but the only problem i have now is that on this form for each record the combo box stays the same for every record.

So for record 1 i choose a peticular service.
1) "service A"

Then when i go to record 2, it keeps the same choice as in record 1. and when i change it keeps the same record for each record.

Now i need this to stay for each record since certain records have different services. If someone could help me now this would help so much.

Thanks
-Jon