open to new record offset

[ShostyFan]

I have a form and in the onLoad control: DoCmd.GoToRecord , , acNewRecThe issue is when I need to open the form to a specific record, it obviously will not because of the onLoad event.



When I remove the onload event and put the same code into a button from a main menu the form opens as expected but I can't scroll or filter a record until I create something new and that does not work for the users.

What I need is for the form to open to a new record and be able to scroll or search before entering in something new and be able to open the same record from a different form that will go to a specific record.

Thanks.

[NTC]

Your set up with the GoTo New does allow you then to find another record if you wish. So your issue is when you open the form telling it a specific record to open with. This technique puts that record ID in the filter. You can see it if you put the form into design view and look at the filter property. So what you need to do is via an event/button clear the filter.

[ShostyFan]

I'm not following the Clear Filter button solution. In the form properties I turned off allow form filter, and there was no change. Maybe this is more clear:
When I open form A, everything works as expected, I get a new record and I can scroll through records.
When I open Form A but to a specific record the form still opens to a new record and the user has to scroll back 1. My open form to record vba is:
DoCmd.OpenForm "Frm Cash Register", acNormal, , "[WorkOrderNumber] = " & Me.WO_Number

Is the "clear filter" solution correct and the issue is that I am implementing it wrong?