opening a form with a date

[techkenny1]

Hi,
How do I change this code so that a form will open by using the on click event.
I have tried this code, but only get an error,
"DoCmd.Openform "Form125Sch_3", , , "Date=" & Me.Date"

regards,
KP

 

[danvlas]

DoCmd.Openform "Form125Sch_3", , , "Date=#" & Me.Date & "#"

Good luck


Daniel Vlas
Systems Consultant

 

[techkenny1]

Many thanks for your reply.
I have used this code,the form opens ok, but the data with the corresponing data does not show.

If I just open the form by itself, the data is there.

Is there any other variation on this code that I can try to get it to work?
KP

 

[danvlas]

DoCmd.Openform "Form125Sch_3", , , "[Date]=#" & Me.Date & "#"

If at all possible, change the field name from "Date" to anything else.
In the future, avoid using reserved names at all costs.



Daniel Vlas
Systems Consultant

 

[techkenny1]

Thank you Daniel, for your great reply.
Its another valuable lesson learnt. Ive changed the field to relect a different name.
And it works reall ygreat.

Thank you
KP