Enter parameter value

[Roberto]

Hello,

I have designed a form and everytime I run it, it requests parameters for
two fields that used to be on the form but that I have removed from the table
(and the form). However, they still appear on the field list of the form and
thus request parameter values everytime I want to view the form. I cannot
remove those two fields from the field list. It may be something simple, but
I am getting frustrated.

Thanks and I would appreciate any help.

rg

 

[Roger Carlson]

If it is still in the field list, that means it is still in the Record
Source of the form. The Record Source could be a saved query or a SQL
statement. Either way, you need to remove it from there as well.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Roberto]

Roger,

Thank you for your prompt response. I did find the two fields on a SQL
statement, deleted them and now works fine. Thank you very much! Although, I
do not know how it got into the SQL statement.

rg