display values in a combox on a form with two cols into a table i.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a invoice table with two fields cc_code and cc_name. to enter values
into these two fields i have a combo box on a form with two cols and when iam
saving a record, i have typed it as rs1.cc_code=combobox.column(0) and
rs1.cc_name=combobox.column(1). it works perfectly. but now when iam
preparing a update query iam unable to use the same for e.g.
cc_code=[Forms]![Invoice]![comboboc.column(0)]. it is giving the error
function not defined.

thanx
bye
 
On occassion I have had the same problem. To get round
it I created two controls on the form with the control
source set to '=combobox.column(0)' and '=combobox.column
(1)'. I have then used these fields as the source for
the update query.

-----Original Message-----
i have a invoice table with two fields cc_code and cc_name. to enter values
into these two fields i have a combo box on a form with two cols and when iam
saving a record, i have typed it as
Click to expand...
rs1.cc_code=combobox.column(0) and
rs1.cc_name=combobox.column(1). it works perfectly. but now when iam
preparing a update query iam unable to use the same for e.g.
cc_code=[Forms]![Invoice]![comboboc.column(0)]. it is giving the error
function not defined.

thanx
bye
.
Click to expand...
 
Back
Top