I have a pop up form that displays delivered products. This form has a button on it that allows the user to re-deliver some of the product which has been rejected:
The user needs to select the product they wish to redeliver and then press the "Reject Product" button.
This will then open a NEW blank delivery form with the selected product details so the user can deliver the rejected product to a new client.
The problem i'm having is the VBA to open the form:
DoCmd.OpenForm "form-Delivery", , , , acFormAdd, , argumentsString
Does nothing. I am a bit confused by this. Do i need to effectively close the form in the VBA for the button press to open it again?
Hope this makes sense. Basically the upshot is i want to open the same popup form but with a blank record.
Thanks in advance
Glen
The user needs to select the product they wish to redeliver and then press the "Reject Product" button.
This will then open a NEW blank delivery form with the selected product details so the user can deliver the rejected product to a new client.
The problem i'm having is the VBA to open the form:
DoCmd.OpenForm "form-Delivery", , , , acFormAdd, , argumentsString
Does nothing. I am a bit confused by this. Do i need to effectively close the form in the VBA for the button press to open it again?
Hope this makes sense. Basically the upshot is i want to open the same popup form but with a blank record.
Thanks in advance
Glen