Spelthorne1
Registered User.
- Local time
- Today, 07:15
- Joined
- Feb 17, 2004
- Messages
- 20
Ive got a db that has a form that will hopefully control the queries.
The value Yes needs to be in the criteria for certain columns. I would like a select button on the form to acheive this.
Therefore, in the onclick event for the select button ive:
If selectbutton.value = -1 then
criteria = "Yes"
else Criteria = "No"
end if
When the select box is ticked criteria = Yes. How do i get this value into the qurey criteria section.
Ive tried
[Form]![Form1]![criteria.text] but when the query is run it says you cancelled the query.
thanks
The value Yes needs to be in the criteria for certain columns. I would like a select button on the form to acheive this.
Therefore, in the onclick event for the select button ive:
If selectbutton.value = -1 then
criteria = "Yes"
else Criteria = "No"
end if
When the select box is ticked criteria = Yes. How do i get this value into the qurey criteria section.
Ive tried
[Form]![Form1]![criteria.text] but when the query is run it says you cancelled the query.
thanks