This is new I have made it so a field populates on another form but for some reason this isnt working. This is the code I am using on my Button

Private Sub cmdCreateQuote2_Click()

'Save the record
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

'Open a new quote
DoCmd.OpenForm "frmCreateQuote", acNormal, , , acFormAdd

'Transfer CustomerID to New Form
Forms!frmCreateQuote!CustomerID = Forms!AddCustomer!CustomerID

'Close AddCustomer
DoCmd.Close

Other Info:
-the screen opens and closes
-I tried moving the DoCmd.Close up in the order and the frmcreate quote opens but then I get an error in the line that says:

Forms!frmCreateQuote!CustomerID = Forms!AddCustomer!CustomerID

-I triple checked the field names they are correct

As usual I am probably missing something simple.

If you want to pass data between forms, the easiest way I have found is with public variables.

Create a module, and then add this line to the module:

Public pCustID As Integer

'I am assuming that the customer ID you are passing is an autonumber.

Then on the On Click event of the button to open the frmCreateQuote, just open the form, and put this code in:

pCustID = Me.CustomerID

Then on the On Load or On Open event of the frmCreateQuote form, put this code:

Me.CustomerID = pCustID

Did that work?



mmcdonal