Enter Parameter Value

[rexmorgan]

So I have this database that I have been working on. There are fields for Latitude and Longitude in both decimal and degree minutes seconds format. Initially I was entering each of these values separately. But in the last few days as I began actually putting a lot of data into the table I realized what a PITA this was so I created a function so that I could just calculate one of those values based on the other.

I opted to calculated the DDDMMSS value based on the input value from the decimal lat and long. The function works well and all.

I decided that I could now do away with the fields in the table that referenced the DDDMMSS. I would only have them on a form and I can use the function to calculated that data.

After deleting the field in the table, when I try to open the form I now get the annoying popup Enter Parameter Value Spotter.Lat Deg Min Sec

Table name is Spotter
Form name is SpotterForm

Why am I now getting the popup. The data no longer exists. Any help is greatly appreciated. Sorry for the long post. I had hoped to explain thoroughly.

 

[DCrake]

You must have the orignial field still being referenced somewhere in the form maybe as a control source or in some sql.

 

[rexmorgan]

Well I searched everywhere or so I thought. I went so far as to delete every single thing off of the form, but still got the error. Then I accidentally was clicking on the form in design view and noticed the Property sheet for the form. There is was a reference to the field that did not exist. The 'Record Source' of the property sheet still had a reference to the deleted field. Once I corrected the entry for the 'Record Source' all is well. Thanks for the help.