Science is an attempt, largely successful, to understand the world... Microbiology and meteorology now explain what only a few centuries ago was considered sufficient cause to burn women to death.
Thank you, Kevin Robertson, for your valuable advice. It was indeed the problem, and after adding the ID field into the Query, things worked out!
However, it's not quite worked out yet, as the list came back as blank when clearing out all search and requery. In fact, when I open the list form, it is blank. I'll have to put in the begin year and end year search in order to get the full list (or by click on the clear search button which default begin year and end year), as the default values in data in the property sheet still return the form blank. Although I can work with this, it seems bizzard. Would you be able to advise what might be the problem?
Below is the VBA code, following the Search Form 2.0 video instructions. If I change BeginYearSearch and EndYearSearch to = "", then the list is blank. The data type for both BeginYearSearch and EndYearSearch is short text, but the text is extracted (via a vba code) from a long text field that contains the number.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.