No Default Value

[Trevor Hughes]

Hello

I am experiencing a problem with a query referenced by a script I am running.

The error is:
Error in: B2B Lodgement
Line: 10 - Parameter
[Forms]![Goods]![Test environment] has no default value

This relates to a Microsoft Access query which is referencing a field on a form.
DBQuery>GoodsTesting,Select * From qryXMLLodgementsImportExport,rDEC,NumRecs,NumFields,0

If I remove the form reference the script works fine.

Can anyone suggest a solution to this problem.

Any help would be appreciated.

[JRL]

Can you query a form? Am I missing something? In my experience you would query a table. A form is a method to view the contents of a table usually one record at a time.

What part of the DBQuery> line is the "form reference" that is removed to make the script work?

[Marcus Tettmar]

As JRL says, Macro Scheduler has no knowledge of your "form" and can't query it. It can only query a table or query.