Enter parameter value keeps appearing when I open a form

Question

I have a database that I have altered from a template to better fit my needs. I keep getting "Enter Parameter Value: ID" and "Enter Parameter Value: Student" every time I open the form. I have check code, checked queries, and I cannot find the source of the problem. The values ID and Student do not exist anymore in queries or tables, so I cannot figure out why it is still popping up when I open the form. I am only mildly advanced in Access, so any help is appreciated!

Answer 1

Just a guess.  Open the query in design view.  Right click and open the properties box.  Look in the Order By row.  Do the same in the form (in the Properties box, Data Column, look in the Order By row)

It may be something else, but always try the simple things 1st.

Answer 2

Open the query that feeds the form - does it ask you for anything?

Next. Go to the form and search the form's VBA for a reference to a field that you say isn't.

As an example it may say

Private Sub Form_Current()

Me.SomeControlName = "Some text message"

End Sub

If there is no control called SomeControlName then you have found your problem.

Next whilst you are in the form's code try to compile the database (on the Debug Tab) and see if anything crops up

As I said, something is looking for something.  You just need to find out what

Answer 3

I do not have any reports associated with the tables or the forms. I checked all "order by" and they are blank. I am stumped!

Answer 4

Oh, and be sure to check the Sort/Group list of fields/expressions too.

Answer 5

Check the report.  Because of the way reports work, all control source bound field names and expression term names that can not be resolved in the report's record source table/query automatically generate a prompt.