Hello all. I have a form called "EditVendor" that allows you to edit a vendors details and I have a button called "SaveAndClose" that closes the form and opens up another form and goes to the same record. Heres the code (I know my names are sloppy):
DoCmd.OpenForm "frm_Vendors", , , "[VendorID]=" & Nz(Me![VendorID], 0)
It works great, but it of course filters the opened form and it wont allow you to flip through records in Navigation. I know if I just click the filtered button it will allow it but the people using the form will not. Any work arounds out there?
DoCmd.OpenForm "frm_Vendors", , , "[VendorID]=" & Nz(Me![VendorID], 0)
It works great, but it of course filters the opened form and it wont allow you to flip through records in Navigation. I know if I just click the filtered button it will allow it but the people using the form will not. Any work arounds out there?