Copy all records from an Combo Box to the Form

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hello,

On the Form
Have a combo box that uses the following:
Row Source Type = Table / Query
ROW Source = SELECT DISTINCT [tblRequest].[Company],
[tblRequest].[Address], [tblRequest].[Suite #],
[tblRequest].[City], [tblRequest].[State], [tblRequest].
[Zip] FROM tblRequest WHERE ((([tblRequest].[Company]) Is
Not Null));

On Events for the combo Box
After Update = Would like to copy the select records and
fileds to the form fields or Table.


Thanks in Advanced!
Jimmy
 
Jimmy,

you have 6 columns in you combo box, you can access each of the fields by
referring to the column property of the combo.

To set a field on the form to a value from the selection in the combo use
the syntax filedname = combo.column(n)
eg me.txtCompany = combo.column(0)

note the column count is zero based.
 
Back
Top