Form opened in form view is completely blank 2

[steve728]

I'm using Access 2000. Just 1 of my forms is giving me grief. The backend recordsource is not providing the form with a record to display on the form, therefore all is blank. I'm using a finction in one of the criteria fields to filter out the record I want displayed. (i.e. Getpo())
In the open event of the form I used msgbox Getpo() to make certain that the value is correctly being entered into the query. It is. I verify that the correct record is being selected by clicking of the dataview for the query. The record is there. I made sure that the header/footer is not too big. I'm not using any query joins. The filter & orderby filter is blank. I noticed that the form displays perfectly if I click on the Record menu / Remove Filter/Sort option. The form works perfectly if I close the form and immediately double click on it where it is stored in the form tab of the database container. Please help me. This problem is really setting me back!

I'll appreciate any help you can offer.

Steve

 

[KornGeek]

Rick,
I'm giving you a star for teaching me something new. I've never encountered a "race condition" in my code (that I know of), but that might explain some problems I once wrestled with.

Thanks for the education.