Form Design

[paulS30berks]

I have set up a form that picks up reports from my database.

The structure of this form is:

Select Company Code Unbound
Select Report Drop down list of reports linked
Year and Period

*** The company code refers to 5 different company codes.

The report is then linked to a select query. Criteria has been written into company code field:

Company code
[Forms]![frmMissingClientCodes]![cmpcode]

If I select company code then a report and then type in my year and period on the form I receive a parameter box which asks me to enter company code.

Does anyone know why this is occuring and to prevent this?

Thanks

Paul

 

[KenHigg]

This usually happens when it can't find the field you're referring to. Maybe you've mis-spelled it?

 

[paulS30berks]

Thanks for your reply.

The field seems to be fine. Could this be something to do with the settings in my criteria within the query?

 

[paulS30berks]

Thanks for your reply.

The field seems to be fine. Could this be something to do with the settings in my criteria within the query?

 

[paulS30berks]

Apologies had not linked to loaded form. Parameter box not appearing now, however the selection does not filter by company code.

Can you help?