linking to a subform

[gojohnnygogogogo]

hello All,
I use this code through most my access97 databases, but for some reason it doesn't work on one of my databases.

run-time error '3077'
Syntax error (missing operator) in expression.

the code is :

Private Sub List0_AfterUpdate()

Me.Recordsetclone.findfirst "[Companyname] = " & Me![list0]

Me.bookmark = me.recordsetclone.bookmark

any reason why this doesn't work ?


thank you.

 

[KenReay]

Hi

Presumably becuase CompanyNAme is a string, try

Me.Recordsetclone.findfirst "[Companyname] = '" & Me![list0] & "'"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[gojohnnygogogogo]

thank you,
how stupid of me.