Unusal form option

[buckwheat]

I have a very complex data entry that returns results to a table. The table is then brought into a query with numerous calculations. I'm going to need to add an element to the form that will allow users to select either a "fixed" value or a "manual" value for a field. To further explain, there are some rates that are going to be fixed for most of the physicians, there will be a "fixed" table with values that will be referenced in the query if this is selected.

What I'm not sure about doing is the "manual" rate. I was hoping to be able to use a radio buttons or check boxes or maybe a cbo, either way, I need the result to return "fixed" rate to the table as text and if "manual" is selected, I would need for users to be able to enter that value and return it to the form as a value . . . can anyone guide me on the best way to accomplish this please?

[June7]

Could use a bound combobox and set LimitToList property to No. Anything else will require code.

[buckwheat]

ok thanks for the advice