best way to do this

[icemonster]

hi, here's my thing.

i have a table with a field called rate, what i want is, on a form that creates the record, i want the rate field to be filled (or populated?) by whatever i click or choose from the combo box, how do i do this? any pointers?

 

[liddlem]

First of all - remove the combo box from your form.
Create a table to store the rates - Populate the table with the rates that are applicable.
Now add a combo box to your form - it should prompt you and ask what it should do with the field that you selected.