How can I read text inputs from a form to run a query.

S

submarine2000

Hi~. please help me...

I'd like to query a data based on the values in a form.
I'd like o know how I can read the bounded input values, and pass it to
query, and find the antena factor, and pass it to the Test subform. How can
I do?
Pleas look at the WHERE condition in the below.

SELECT tblTDS.TDSID, tblTDS.Sensor, tblSensor.SensorID AS
tblSensor_SensorID, tblSensorLevel.SensorLevelID,
tblSensorLevel.SensorFrequencyFrom, tblSensorLevel.SensorFrequencyFromHz,
tblSensorLevel.SensorFrequencyTo, tblSensorLevel.SensorFrequencyToHz,
tblSensorLevel.AntenaFactor, tblSensorLevel.SensorID AS
tblSensorLevel_SensorID, tblTest.TestID, tblTest.TestFrequency,
tblTest.TestFrequencyHz, tblTest.AntennaFactor
FROM ((tblSensor INNER JOIN tblSensorLevel ON tblSensor.SensorID =
tblSensorLevel.SensorID) INNER JOIN tblTDS ON tblSensor.SensorID =
tblTDS.Sensor) INNER JOIN tblTest ON tblTDS.TDSID = tblTest.TDSID
WHERE (((tblTDS.TDSID)=6) AND ((tblTDS.Sensor)=1) AND
((tblSensorLevel.SensorFrequencyFrom)<=10) AND
((tblSensorLevel.SensorFrequencyFromHz)=3) AND
((tblSensorLevel.SensorFrequencyTo)>=10) AND
((tblSensorLevel.SensorFrequencyToHz)=3) AND ((tblTest.TestID)=15));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top