Strange message when opening a table

[dbar10]

I have a pretty large application that I am creating and in the process of developing this I started receiving a strange message when opening the table - [Scheduletbl] from the frontend database. It's an "Enter Parameter Value" message:
Forms!SchedSearchList!ScheduleClientfrm.Form!ComboJob

I can hit enter or enter any number and the table opens. But I am creating another query on this table and it won't run without this message coming up first.

This doesn't happen when I open the table from the backend source. I very concerned that this is going to cause me problems. Any ideas on what I can do to get rid of this?

 

[dhookom]

I would take a look at the filter property of the table. You may need to append the records to a new table, rename and relink the table.

Duane
Hook'D on Access
MS Access MVP

 

[dbar10]

Thanks DHookom. The filter property was empty so I did a make table query and that worked great. Wierd things happen in this world don't they? Appreciate your help

 

[GKChesterton]

A good occasion for the "Thank dhookom for this valuable post!" link.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​