how do I link a text box to a column in Access?

M

Malakeem

It has been so long, I am a new user at best.
I have a DB I created some time ago. I wanted to ad a new column to the
main page, and have the data type be a single word of text. I have the column
created. However, in the box on the form that is to display this colum, ai
can not get any information to come up in the text box. I get the line: #Name?
I assume this meand it cannot find the information. So I need to know how to
correctly link the box with the information. Any help would be appreciated.
Thanks
 
D

Duane Hookom

Forms have Record Source properties. This is usually a table, query, or SQL
statement. Your record source query should contain the "new column".

You might want to use terms like "field" rather than "column" and I don't
know what you mean by "main page".
 
M

Malakeem

Thanks Duane, sorry so vague. I am still a bit (ok, alot) rusty. I'll see
where I missed the field name. By main page I mean the page that is displayed
when a record is quired. The box is there with the error instead of the
information. Time for me & the tutorials to meet again...
Malakeem.
 
M

Malakeem

Thanks Tom for the answer & quick response. The article & you may have
answered my question. I'll look it over.
Malakeem
 
T

Tom Wickerath

Hi Malakeem,

The control source for the textbox should be the name of the new field that
you added. If your form is based on a query (either a saved query or a SELECT
statement), then you'll need to add this field to the recordsource first. In
form design view, you can click on View > Field List to see a listing of all
fields that are available to your form. Is your new field included?

Here is a KB article that you might find useful. While the title includes
ACC2000, it applies to all versions of Access:

ACC2000: Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

It has been so long, I am a new user at best.
I have a DB I created some time ago. I wanted to ad a new column to the
main page, and have the data type be a single word of text. I have the column
created. However, in the box on the form that is to display this colum, ai
can not get any information to come up in the text box. I get the line: #Name?
I assume this meand it cannot find the information. So I need to know how to
correctly link the box with the information. Any help would be appreciated.
Thanks
 
Top