Bob's idea looks good. Will there be more than one record that meets that criteria?
Just for the record Rod, Run SQL command is only for Action Queries, eg; DELETE, DROP, CREATE, APPEND, UPDATE etc...
And finally, even easier would be...
Me.txtBlindOptionsTotal = DLookUp("OptionPrice","RollerAmbienceSystem","opti onNumber = " & me!ambiencerolleroptiongroup.value)
This will change with the option group. You can put this directly in the controlsource property of txtBlindOptionsTotal, or through the command button as before.