pass parameter from combo box with multiple columns

[JulieS]

I have a combo box that lists titles and dates of events.
There could be duplicate titles but not dates, that's why I've listed them both in one combo box.
I would like to pass both the title and date to my query, however the syntax in the query's criteria field:
[forms]![frm_Name]![cbx_TitleDate].column(1)
is not working. (neither is .column(2))
Bound column = 1.
Wondering if I can even do such a thing?

 

[Crowley16]

column count starts at 0

--------------------
Procrastinate Now!

 

[JulieS]

Yep I know. It still says 'undefined function ... in expression'.

 

[PHV]

Create 2 hidden textbox (eg txtTitle and txtDate)
Before launching your query (or in the AfterUpdate event procedure of cbx_TitleDate):
Me!txtTitle = cbx_TitleDate
Me!txtDate = cbx_TitleDate.Column(1)

The query can now grab the values you want:
[Forms]![frm_Name]![txtTitle] and [Forms]![frm_Name]![txtDate]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JulieS]

Works like a charm, thanks.