Date Criteria in a query on a form

Topic

New Reply

Date Criteria in a query on a form

I want to put the Criteria of a date, say >#2000-01-01# on a form,So that the user could easily change the Date Criteria on a form, without opening a query. Is it possible ?

Reply | Quote

Replies

Yes,
Create the form and place a few controls on it – command button to close, command button to run query,text box to hold criteria value etc
supposing the form is called frmCriteria and the text box is called txtCriteria. Set up a query to run when the command button is pressed that uses in it’s criteeria row the expression frmCriteria!txtCriteria and the results should be returned accordingly
HTH

Reply | Quote

Hi,
I get the impression from your question that you’re not trying to do something quite as simple as the solution fatherjack provided – i.e. that you want to be able to include the > (or < etc.) on the form? That's not quite as easy to do and does require some code. If you're familiar with VBA then check out BuildCriteria in the help screens – I suspect your best bet is to use that in conjunction with an SQL string which you then execute.
If that's unclear then please repost and I'll try and clarify.

Reply | Quote

Yep i agree with that, it looks like i pressed ‘post it’ without comparing my response and the question.
apologies.

Reply | Quote