Referencing Form Fields in SQL Queries

I have a Combo Box that I want the User to be able to select a field from. I then want to reference the field selected in part of an sql query.

So lets say for example, the combo box is named Field1 in form Search1. I want the sql statement in a query to do the following.

Select * From Mydb Where Search1.Field1 > Value AND Search1.Field1 < Value;

So I just need to know what i put in place of Search1.Field1.

I figured out what I was doing wrong.