[AccessD] A2K Reference the dot column property in a query

Darren

...you don't need a separate text box or function ...just wrap it with an
Eval as in:

Eval("[Forms]![frmMyForm]![cmbMyCombo].[Column](2)")

...that should keep Access from parsing it as a user function and throwing
an error when it finds none ...HTH :)

William Hindman
"the world is full of trickery. But let this not blind you to what virtue
there is; many persons strive for high ideals, and everywhere life is
full of heroism." ...from Desiderata


----- Original Message ----- 
From: "Darren DICK" <d.dick at uws.edu.au>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, September 05, 2003 12:35 AM
Subject: Re: [AccessD] A2K Reference the dot column property in a query


> Thanks Rocky and Joshua
> Yes That's what I have done - Put a hidden control on the form and
referenced that.
> Even though your/my way works, I just thought there must be a 'real' way
to do it.
>
> Thanks heaps for responding guys
>
> Darren
>
> ----- Original Message -----
> From: "Joshua B" <lists at jbsolutions.com.au>
> To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
> Sent: Friday, September 05, 2003 2:29 PM
> Subject: Re: [AccessD] A2K Reference the dot column property in a query
>
>
> >
> > Rockys way will work just as well as mine, what I have done is to put a
hidden text box on the form and make its controlsource =
> Forms!frmMyForm!cmbMyCombo.Column(2). Then, in the query, instead of
referencing the combo, reference the hidden text box...
> >
> >
> >
> > ======= At 2003-09-04, 20:50:00 you wrote: =======
> >
> > >I know there must be a solution to this problem but I've never figured
it
> > >out.  Whenever I run into the problem of referencing a form value in a
query
> > >I always make a public function like:
> > >
> > >Public Function GetComboValue
> > >    GetComboValue=Forms!frmMyForm!cmbMyCombo.Column(2)
> > >End Function
> > >
> > >Then in the query you can put GetComboValue() and it will return the
value.
> > >
> > >Seems there should be a better way though.
> > >
> > >Rocky
> > >
> > >----- Original Message -----
> > >From: "Darren DICK" <d.dick at uws.edu.au>
> > >To: "AccessD List" <AccessD at databaseadvisors.com>
> > >Sent: Thursday, September 04, 2003 8:34 PM
> > >Subject: [AccessD] A2K Reference the dot column property in a query
> > >
> > >
> > >> Hello all
> > >> In VBA the code to reference certain columns in a combo box on a form
> > >is...
> > >> Forms!frmMyForm!cmbMyCombo.Colum(2)  - Cool it all works
> > >> But when I use the same syntax in a query I get errors - namely
> > >> Undefined function '[Forms]!frmMyForm!cmbMyCombo.Column' in
expression
> > >>
> > >> What should I type to reference a particular column of a combo in a
query?
> > >>
> > >> Many thanks in advance
> > >>
> > >> Darren
> > >>
> > >>
> > >> _______________________________________________
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> http://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > >
> > >_______________________________________________
> > >AccessD mailing list
> > >AccessD at databaseadvisors.com
> > >http://databaseadvisors.com/mailman/listinfo/accessd
> > >Website: http://www.databaseadvisors.com
> >
> > = = = = = = = = = = = = = = = = = = = =
> >
> >
> > Best regards.
> > Joshua B
> > lists at jbsolutions.com.au
> > www.jbsolutions.com.au
> > 2003-09-05
> >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>