MS Access 2010 VBA Code for a button to seach a form by date

[system243trd]

I have a form (Form 1)that contains a text box (set as a date picker) and a button.


I have a second form (Form 2) that contains data including a date field.
I would like to create some code behind the button on Form 1 so that when the date is selected and the button is pressed then Form 2 will open with the data from the specific date selected in Form1.
Thanks

[pbaldy]

One way:

http://www.baldyweb.com/wherecondition.htm

[system243trd]

I can't understand why it wont work.
I have used the following code

DoCmd.OpenForm "frmMainExercise", , , "Exercise_Date = #" & Me.Text0 & "#"

The Exercise_Date is the date on the form being opened and the Text0 is the date on the search form. Both fields are set a General date fields. When I select the date from Text0 and then select the button, a new record is displayed rather than finding the record with that date.

[pbaldy]

Is it possible the date field has a time component in it?

[system243trd]

The field within the table is a datetime data type and the format is short date. On the form I have set both fields to short date. Could the date have something to do with this?

[pbaldy]

If the value contains a time it would. Try

DoCmd.OpenForm "frmMainExercise", , , "DateValue(Exercise_Date) = #" & Me.Text0 & "#"

[system243trd]

Thanks pbaldy I have tried this but it still doesn't work I wonder if there is a problem with Access and not my code :s

[pbaldy]

Can you post the db here?

[system243trd]

I have tried to attach the file but it is too large. &nbsp;It needs to be under 500k and is currently 700k.<br>I have used winrar to try and upload but it does not accept this type of file.<br>Is there any way I can compress the file and attach it?<br><br>

[system243trd]

I have tried to attach the file but it is too large. It needs to be under 500k and is currently 700k.<br>
I have used winrar to try and upload but it does not accept this type of file.<br>
Is there any way I can compress the file and attach it?<br>
<br>

[system243trd]

Hi,
Please find the file attached. The form which contains the code is frmfindexercisedate which opens frmMainexercise.

Thanks

[pbaldy]

It appears to be working fine. Is any code running for you? The db needs to be in a trusted location, or you have to explicitly enable code.

[system243trd]

Yes some of the code is running for me. I think the database is running from a trusted location, I have copied the database to my desktop and enabled the content. On the FormfindExercise when I enter a date into the text box and then select the Search Exercise button, the FrmMainExercise form opens but does not filter the data. This proves that the code is working to some degree. I am using Access 2010 if that has anything to do with the issue?