Form wants Parameter Value for a field not on the form

[cmyers]

So I saw a thread about this back from 2007, but it died and didn't go anywhere. I've created a from specifically to add new records, which runs the "GoToRecord" macro with the condition "New". It's got tabs, one for a new contact, one for a new course, etc. When I open the form however, it asks me for a value to a field that isn't on the form. I've checked and it doesn't show up in any of the fields, and isn't relevant to the possible new records. Any thoughts?

[orange]

You may have some corruption. Have you tried a Compact and Repair?

[ssanfu]

Also check the spelling of the field in the error message. I get these errors when I am typing too fast (rrriiight..) for the computer to keep up with.

Check the query of the form?

BTW, no macro needed if the macro just saves the record (I never use macros!!)..... just set the form to Data Entry Mode.
Open the form on design view.
Click on the data tab.
Look for the "Data Entry" property - set it to Yes.

[cmyers]

Also check the spelling of the field in the error message. I get these errors when I am typing too fast (rrriiight..) for the computer to keep up with.

Check the query of the form?

BTW, no macro needed if the macro just saves the record (I never use macros!!)..... just set the form to Data Entry Mode.
Open the form on design view.
Click on the data tab.
Look for the "Data Entry" property - set it to Yes.

SSanfu nailed it - I remembered I deleted the column and created a new one in it's name cause I needed to change the data type of the field. The query wanted the old field's value, so I just deleted it from the query and it worked fine. And changing it to Data Entry Mode worked like a charm as well, much simpler way to do that. Thanks for the help guys, great forum with quick and helpful responses!