Hi all,
I'm sure the topic of random records has made the rounds and I haven't been able to find anything on my particular question so I thought I would ask. I want to perform cycle counts in the warehouse. I'm using a simple query mainly because I don't know how to write VBA or SQL. What seems to happen is every time the database is opened initially, the same group of records are displayed. I've added a command button to the form so staff know to click the button before a count form is printed, but I was hoping to find a way to set the query to load a fresh set of records each time the db is opened. In the OnLoad, I tried a couple simple DoCmd.Requery and DoCmd.GoToRecord acDataform, "Cycle Counts",acNewRecord with no luck so any suggestions will be appreciated. I've also added my query in the remote case I can do a simple fix...
Thank you for any suggestions...