Forms asks for Parameter

[Taff]

When i try and open my form it asks me for a parameter value for a field that doesn't exist.

Any Ideas?


Thanks All


Anthony

 

[dcx693]

What is the form's recordsource? It could be a query that is looking for a field that doesn't exist.

 

[Taff]

The Record source is a table.

It does not matter what value i enter to the paramater box or if i click cancel. It does not seem to do anything.

Strange.

 

[dcx693]

What parameter is it asking for? Is it similar to any field names? Do you have any code in the Open, Current or Load events of your form?

 

[Mile-O]

Does your form have a combo, listbox, subform (with combo, listbox, subform (with combo or listbox)) on it as these are also queried as the form opens.

Any of these could be missing a parameter which will either indicate a spelling mistake or a field deleted from a table or query that is still being pointed to.

 

[Taff]

Hi All,

Sorted now.

It was a field referenced on the on open event of my form which now no longer exists.

Thanks

Ant