[AccessD] Query expression refers to column(1) on a form

Also, in case i am wrong, and that isnt sufficient, have you tried building
something similar in the designer with that for reference in the where,
then checked the SQL view to see what Access translated to? I seldom try
writing SQL from scratch anymore,  I too am getting rusty.
On Sep 30, 2014 8:33 PM, "David McAfee" <davidmcafee at gmail.com> wrote:

> So this is weird, I know I've done this before, I've just been away from
> Access for too long (I think).
>
> I assumed that I can create an expression in a query that would refer to a
> column of a combo box on a form as such:
>
> Expr1: Forms![frmBuild]![cboBuildType].Column(1)
>
> I get an error when I try to run the query: Undefined Function 'Expr1:
> Forms![frmBuild]![cboBuildType].Column' in experession
>
> (notice the column number is missing)
>
> When I enter  ? Forms![frmBuild]![cboBuildType].Column(1) in the immediate
> window, it displays the value as expected
>
> I made a work around to get this going by creating a public function and
> calling it as such:
>
> Expr2: GetBatchName()
>
>
> Public Function GetBatchName()
>     GetBatchName = Forms![frmBuild]![cboBuildType].Column(1) & " " &
> Format(Forms![frmBuild]![cboMonth].Column(2), "yyyymmdd")
> End Function
>
> I know, I know, there isn't any error handling, just testing it out...
>
> Anyway, what am I forgetting?
>
> It's been a  while.
>
> D
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>