Form does not open - instead displays Lookup message

[stleggs]

I am having great frustration and am hoping someone can help. I work at a college and in our admissions database is a button that allow on click to open the Potential Students Form. That worked great until today - on that form was a value list that I changed to a table/query. After I made that change, when you were on the main menu and clicked on the View Potential Students button is displayed an error message that read "Run-Time Error '3615' Type mismatch in expression." I have no idea that this means. So I went and changed the table/query back to a value list - well now when you click on the view potential students a box appears that says "Lookup_Interest.Interest" and it wants me to enter something - all I want is the View Potential Students button to open that form and then the Interest to be a pulldown menu that allows to select from the linked table. When I cancel the Lookup box another "RunTime Error '2501' The OpenForm action was canceled. " Then the DeBug takes me to the command (which is correct) DoCmd.Open Form "PotentialStudents"
Any ideas???????

 

[Pathetique]

if i understand you correctly i think your problem is simple. keep or recreate the table you want to use, then use that table for the row source property in the Interest combo box. try to delete the button that opens the form and then make a new button to open the form. this will eliminate any bad references in the code from being used. does this sound like I'm the right track

path

 

[adwaitjoshi]

I think what is happening is that since you changed the property of the table/query its not having the reference to the fields in that table. What you might want to try is when it gives the error and asks you to select the table please type in the name of the table and corresponding field or if you think what its showing is correct just click ok you will have to do it for many fields (this is my guess) another thing you might want to do is simple. Open the form in design view. Right click on the small black square on the upper left corner click properties and in the properties just reopen the query and close it. It should do it on its own. Try it this might help if not tell me.