setting filter gives 'Automation Error'

[wheelyjon]

I have a database in Access 2000 and I am opening a form then setting a filer to select a particular record. The code I am using is:-

stDocName = "fExtras"
    DoCmd.OpenForm stDocName, acNormal
 
    Forms!fExtras.Filter = "Job_ID = " & Forms!jobs.Job_ID
    Forms!fExtras.FilterOn = True

The form opens fine, but when the filter is set, the first line generates an error - "Automation Error"
I have almost identical code elswhere which works fine
Please has anyone any suggestions?

Wheelyjon

[Scott Price]

I have a database in Access 2000 and I am opening a form then setting a filer to select a particular record. The code I am using is:-

stDocName = "fExtras"
    DoCmd.OpenForm stDocName, acNormal
 
    Forms!fExtras.Filter = "Job_ID = " & Forms!jobs.Job_ID
    Forms!fExtras.FilterOn = True

The form opens fine, but when the filter is set, the first line generates an error - "Automation Error"
I have almost identical code elswhere which works fine
Please has anyone any suggestions?

Wheelyjon

Welcome to the Scipts!

Also, non standard characters in field/control names usually require the use of square brackets: [] around the field name, i.e. [Job_ID]...

Try removing the space between the = and the " in your .Filter line.

Other than that make absolutely sure that all form references are spelled correctly.

Regards,
Scott