Filtering By Forms Problem

[Walk_The_Line]

I am -attempting- to do searches by filter by form, and I have all my records put in, but when I am applying the form, it brings me back up to an empty form.

I removed the filter and what not, so I don't know what else is going on with that.

 

[Rabbie]

Check your form properties. Is your form set up with DataEntry set to Yes on the Data tab of the properties sheet. Set it to No and you will see your data. If it is set to Yes it is positioned at the end of the dataset ready for new data.

 

[Walk_The_Line]

And how do I get to the DataEntry settings? I have ms 2000, and I right click on the form but the Data section is generally blank, and when it is activated (e.g. when I right click on a field) it does not have a section for DataEntry.

 

[Rabbie]

Open the form in Design View. then right click on the black dot in the top left hand corner. Scroll down to highlight properties. Left Click. The properties sheet should open. Left click on the data tab. scroll down to Dataentry. The value should be set to No if you want to see the current records.

 

[Rabbie]

You need to be sure you are looking at the Form properties not section or field properties

 

[Walk_The_Line]

Yes, data entry is infact set to "no."

Therefore, I should be able to run as many filter by forms as I need to, without it coming back to a blank field, correct?

 

[Rabbie]

DataEntry set to Yes is the most common reason why a form is not showing data. Does your form now show data if you just open it without filtering it. If it does then your filtered form should show all data that passes through the filter.

If you change the filter value you may need to refresh/requery the form to show the data.

 

[Walk_The_Line]

It works but for only a few times. Sometimes it just goes back to blank fields.