Query Date Problem with .ADP using VBA

[carlp69]

I have the following statement in VBA that works fine on a .MBD Database, But does not work on a .ADP Project. The error is 'Incorrect syntax near '#'

Can anybody tell me the correct format for .ADP

Me.Form.RecordSource = "select * from qry_leave WHERE [startdate] = #" & Format(me.parent![Startdate], "mm/dd/yyyy&quot & "#"

Cheers

carlp69

 

[carlp69]

For future Reference

I've sorted it.

Replace the # with '

carlp69