Passing a value from One control to another control with 2 columns,one hidden

  • Thread starter Thread starter nouveauricheinvestments
  • Start date Start date
N

nouveauricheinvestments

Hi,

I'm trying to set the value of a combo box to a value in a control on
the form it is loading from using the following code. All of the
controls below are textboxes other than 'Manager'. I cannot figure
out how to set the value of a combo box with multiple columns. It
gives me an error saying 'Object Required'

By the way, all of the following work fine with passing the value
except for the manager. Just to make that part clear...


Private Sub DocumentTicket_Click()
DoCmd.OpenForm "DocumentATicket"
Form_DocumentATicket.Account = Form_OpenTicketsSubform.Account
Form_DocumentATicket.Description = Form_OpenTicketsSubform.Explanation
Form_DocumentATicket.StartTime = Form_OpenTicketsSubform.DAT
Form_DocumentATicket.Manager.Column(1) =
Form_OpenTicketsSubform.Manager

End Sub
 
You can't set the value of a column. You need to set the value of the
control itself.

Form_DocumentATicket.Manager = Form_OpenTicketsSubform.Manager
 
Back
Top