SQL & VBA

[dodgyone]

Could somebody please tell me what is wrong with the following code... I'm using it to change the recordsource on a form when it opens using VBA...

Me.RecordSource = "SELECT Table1.ID, Table1.Name FROM Table1 WHERE (((Table1.Name) Like "Marcus&quot);"

Many Thanks,
Marcus

 

[MangroBongacello]

Try single quotes on Marcus -> 'Marcus'.

 

[THoey]

Also, don't you need the "*" to use the LIKE clause? Terry M. Hoey

 

[dodgyone]

yep.. did both minutes after posting the question... it amazes me how many times you panic, post the question and then just solve it minutes later )

Cheers for being so speedy though...