Auto Direct to Another Form

[Zacharyjuniorman]

I have a form that users record customer complaints. At the bottom of the form you have three choices, Issue RGN, Ship Parts, Arrange Visit. I want the button to direct me to an order form where the user will select what items to ship. I want some of the data from the complaint form to be transfered to the order form, such as customer etc..

 

[charityg]

This is a generalized answer, and if you need more help let me know.

Use an option group for the action selection. Then in the afterupdate event of the option group use
if grpName=2 then
docmd.openform "frmOrder"
forms!frmOrder!Customer=Me!Customer
....any other fields you want to transfer
end if