14
I have to be honest as I haven't done an all out search on this problem, due to having to get this database completed by tonight, and this problem just popped up.
Ok the problem is that I have had a nicely working form except when I tried to run through my records (via the form) everytime I pushed the advance button to move to the next record I would get an error message that "something" did not have the correct data blah blah blah. I finally figured the problem out. I had two checkboxes (yes/no) that were causing the problem. One checkbox indicated the conditions were ok at a railroad crossing, thus check the box and go on. Now if all the conditions weren't good, then you keep the first checkbox empty, and check the second checkbox to indicate there was a problem.
So only one checkbox would actually get a checkmark for each record. Unfortunately, Access felt that both checkboxes needed to have a checkmark, thus causing the error statement described above. Once I cleared the error, then the next record would pop up, so basically it was working with a major annoyance in between.
My solution was to delete one of the checkboxes, and convert the other to a textbox, then when I put it on the form, it would become a combo box with two items....yes the crossing is compliant, or sent to SIRP Log.....It works good, except;
Everytime I attempt to open the form, I'm getting a Query parameter box asking for a value for the former SIRP Log checkbox. Ok, this tells me that there is a query tied to the records and they need to be gotten rid of which I've done. I've also eliminated all of the sample data, and confirmed there is no relationships that call for that dang checkbox.
The only place I see ANY reference to the former checkbox is in the field list box, and I can't delete it from there.
Ok, any ideas on how I can track this frustrating error down and fix it? I would sure appreciate any help you can.
As always, thanks for your help
mtgrizzly52
