Combo Box column() probs

indesisiv

Access - What's that?
Local time
Today, 09:09
Joined
Jun 13, 2002
Messages
265
Hi there.
I am using a parameter query based on a form BUT i can't seem to get it to refer to a specific column.

If i have the combo box limited to 1 column then it works fine as i don't need to reference the column property.

So what i need to do is reference the combo.column(1).
I know that what i do on a form is use

[Forms]![frmWeekly]![cboUnitName].Column(1)

But that gives me an error.
unidentifed function ??????

Any help would be fantastic
:confused: :confused: :confused:
Steve
:confused: :confused: :confused:
 
The syntax according to the help is

[forms]![frmweekly]![cboUnitName].[column](1)

I haven't tested it but bear in mind the first column is 0 the 2nd column is 1 etc. Don't know for sure if you may need an = sign at the beginning

=[forms]![frmweekly]![cboUnitName].[column](1)


Hope this helps

Col
 
It still comes up with the same error!!!!
 
indesisiv said:
It still comes up with the same error!!!!

Yes it does:mad:
but it works ok if you don't include the column(1) bit.:confused:

must be missing something simple here:rolleyes:
 
You can't directly.

Put a hidden textbox on your form.
Set its ControlSource to refer to Column 1 of your combo.
Reference this textbox in your query.
 
OK .. no probs...

Shame about that though!

Thanks mile :D & Col
 

Users who are viewing this thread

Back
Top Bottom