Prev: Find Duplicates Query Wizard Question
Next: Emailing a form created from a query
From: Hummingbird7 on 14 May 2010 19:25
Beginner in Access 2007. Question related to queries: concatenante fields.
Does the expression results show in forms? Also, pre-existing lookup data
type in tables, when creating a query for the lookup data, will added data
automatically be udated in the form selection drop-down entry box?
From: John W. Vinson on 14 May 2010 20:08
On Fri, 14 May 2010 16:25:01 -0700, Hummingbird7
<Hummingbird7(a)discussions.microsoft.com> wrote:

>Beginner in Access 2007. Question related to queries: concatenante fields.
>Does the expression results show in forms? Also, pre-existing lookup data
>type in tables, when creating a query for the lookup data, will added data
>automatically be udated in the form selection drop-down entry box?

YOu'll have to explain a bit more.

"concatenate fields" - where? How are you doing so?

If you have a calculated field (such as an expression) in a Query and base a
Form on that query, binding a textbox to that calculated field, yes it will be
visible (but not editable).

Read http://www.mvps.org/access/lookupfields.htm for a critique of what many
of us consider a misdesigned feature. You'll also need to explain what you
mean by "creating a query for the lookup data" and under what circumstances
you want it to be updated.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Find Duplicates Query Wizard Question
Next: Emailing a form created from a query