Record source problem on form

[cmc2005]

Hello,
I'm having a strange problem and was wondering if anyone can help me out. I have a form that is for inputting and modifying data in one table. It used to work when you opened the form you would see x amount of records. Now it's opening to 1 blank record. If you hit filter it fliters like 1700 records and then when you unclick it, you get the entire 10000 records. I thought it had something to do with the Record Source in the properties but when I fixed that it still didn't work. Any ideas?
Thank you!

 

[Kraj]

Could the form have been set to a different mode, like data entry, in the properties? That could cause it to open as a single, blank form. If you use code or a macro to open the form (say via a button) instead of directly clicking on the form, sometimes those routines can set conditions & modes on the forms too.

 

[ScottGem]

Hello,
I'm having a strange problem and was wondering if anyone can help me out. I have a form that is for inputting and modifying data in one table. It used to work when you opened the form you would see x amount of records. Now it's opening to 1 blank record. If you hit filter it fliters like 1700 records and then when you unclick it, you get the entire 10000 records. I thought it had something to do with the Record Source in the properties but when I fixed that it still didn't work. Any ideas?
Thank you!

Make sure the Data Entry property is set to No.