Adding a field created by a query to existing form ?

A

Andy

Hi,

Can anybody tell me how I can accomplish this.

Everytime I try I get a textbox with #name written it.
 
D

DevalilaJohn

How is the field getting onto the form? If you simply drag the field from
your field list onto the form, it should appear as a text box for the data
with a label and work as advertised.

Check the data tab for the text box and make sure that you have spelled the
name correctly, don't have blanks, equals signs, quotes, etc. where they
don't belong.

If you can give some more information, the answer may become clearer.
 
J

John Vinson

Hi,

Can anybody tell me how I can accomplish this.

Everytime I try I get a textbox with #name written it.
Click to expand...

The only fields directly available on a Form are those fields in the
Form's recordsource (which can be a table or, more commonly, a Query).
Are you using one query as the recordsource for the form and then
trying to display a field from a different query? How are the two
queries related, if so? Can you include the calculated field in the
Form's query directly?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top