Using a combobox in a form

[ronwmon]

I need to update a field named BillMonth in a table named TW_Data with the contents of two comboboxes, combo4 and combo6.

Combo4 contains two fields, the month name, ie January February... The second field contains the month number ie 01,02...

Combo6 contains the 4 digit year.

I need to update the field BillMonth in table TW_Data to the month number, "-" and year. Like 01-2014.

My code:

UPDATE TW_Data SET TW_Data.BillMonth = [Forms]![A-Prep]!combo4.column(1) & "-" & combo6
WHERE (((TW_Data.BillMonth) Is Null));

The error I get is "Undefined function '[Forms]![A-Prep]!combo4.column' in expression."

Any help is appreciated.

Ron--

 

[Andrzejek]

First, rename your combo4 and combo6 to something meaningful like cboMonths and cboYear

"Combo4 contains two fields" - do you mean 2 fields concantinated to display:[pre]
January 01
February 02[/pre]

or 2 fields in 2 columns:[pre]
col 1 | col 2
January | 01
February | 02[/pre]

>My code:
>
>UPDATE TW_Data SET TW_Data.BillMonth = [Forms]![A-Prep]!combo4.column(1) & "-" & combo6
>WHERE (((TW_Data.BillMonth) Is Null));

That's not your code.
You code would look something like:

strSQL = " UPDATE TW_Data SET TW_Data.BillMonth = '" & [Forms]![A-Prep]!combo4.column(1) & "-" & combo6 & "' WHERE TW_Data.BillMonth Is Null"



Have fun.

---- Andy

 

[randy700]

I agree with Andy - rename you combo boxes.

Combo4 contains two fields, the month name, ie January February... The second field contains the month number ie 01,02...

The first column is column(0), the second is column(1).




Randy