Hi guys,

I tried issuing "SELECT PayMast.Name,Thisform.Text1.Value AS nRate FROM PayMast" but I get an error "Alias TEXT1 not Found". I resorted to first storing the value of Thisform.Text.Value to a variable, then used the variable in the SQL command instead and that works fine. What is the correct SQL syntax when the SELECT is to include Form object values ?

TIA
Fred Kotte