Forms asks for Parameter (1 Viewer)

Taff

Registered User.

Local time

Today, 20:38

Joined

Feb 3, 2004

Messages

158

• Feb 12, 2004

• #1

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

Registered User.

Local time

Today, 15:38

Joined

Apr 30, 2003

Messages

3,265

• Feb 12, 2004

• #2

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

 

Taff

Registered User.

Local time

Today, 20:38

Joined

Feb 3, 2004

Messages

158

• Feb 12, 2004

• #3

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

Registered User.

Local time

Today, 15:38

Joined

Apr 30, 2003

Messages

3,265

• Feb 12, 2004

• #4

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

Back once again...

Local time

Today, 20:38

Joined

Dec 10, 2002

Messages

11,316

• Feb 12, 2004

• #5

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

Registered User.

Local time

Today, 20:38

Joined

Feb 3, 2004

Messages

158

• Feb 13, 2004

• #6

Hi All,

Sorted now.

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

Thanks

Ant