Why this is not working: column(1)

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

HI.

I trying to create a query with this criteria:

[forms]![64_form_YTD_YTG_Printings]![Combo77]!column(1) and it's not
working. It also retrieves me the folowing information: Undefined Function

What's wrong?

Thanks,
Marco
 
hi,
How about trying this
[forms]![64_form_YTD_YTG_Printings]![Combo77].Column(1)
Click to expand...
And maybe an additional .Form:

[forms]![64_form_YTD_YTG_Printings].Form.[Combo77].Column(1)




mfG
--> stefan <--
 
hello.

Same problem. that was waht I had in first place.


Any ideas?

Marco




Benjamins via AccessMonster.com said:
How about trying this
[forms]![64_form_YTD_YTG_Printings]![Combo77].Column(1)
HI.

I trying to create a query with this criteria:

[forms]![64_form_YTD_YTG_Printings]![Combo77]!column(1) and it's not
working. It also retrieves me the folowing information: Undefined Function

What's wrong?

Thanks,
Marco
Click to expand...
Click to expand...
 
I didn't another thing.

I create a text field in form, then I put that criteria in the combo and
then in criteria instead of putting the combo I put the text. ;)

Cheers,
Marco




Benjamins via AccessMonster.com said:
How about trying this
[forms]![64_form_YTD_YTG_Printings]![Combo77].Column(1)
HI.

I trying to create a query with this criteria:

[forms]![64_form_YTD_YTG_Printings]![Combo77]!column(1) and it's not
working. It also retrieves me the folowing information: Undefined Function

What's wrong?

Thanks,
Marco
Click to expand...
Click to expand...
 
Marco said:
I didn't another thing.

I create a text field in form, then I put that criteria in the combo
and then in criteria instead of putting the combo I put the text. ;)
Click to expand...

You cannot refer to a ComboBox column directly in a query and what you did
is a common work-around.
 
Back
Top