Adding Textbox not in Field List

[krop]

OK, I feel really silly for having to ask this but I can't work it out...

I need to add a simple bound text box to a form in design view.

However, it's not listed in the field list so I can't just drag & drop it and if just draw on a text box then click properties, control source, [...], and select the field name from tables, the text box just returns #Name?

Now I assume this is because access does not know how to link this new field to any of the existing ones. So how do I do this and add new field to the form field. Normally I'd just use the wizard but I really don't want to start a new form - this one has taken me ages to get it to where it is now!

TIA,

 

[IMO]

If it's not listed in the field list then it's not in the table or query that your form is based on, so you'll have to create an unbound textbox and make sure your tables are related correctly, or, add the field to the table or query that your form is based on. If you'd like to post a stripped down version of your DB I'll take a look for you.

IMO

 

[krop]

I can't I'm afraid as the tables are linked tables from an SQL database.

There must be a way to add them or how else do people create forms without using the wizard?

Rgds,

 

[IMO]

Create a Query containing the same fields as the table your form is based on adding the extra field within the query, then change the Record Source of the form to your new query. Now you can drag and drop from the field list.

IMO

 

[krop]

Thanks very much, IMO! Why on earth was I using the Form Wizard instead of basing my form on queries in the first place!?

It works now and I'll be able to add extra fields on easily at a later date.

Thanks again!

 

[IMO]

Glad you got it working

IMO

 

[Pat Hartman]

You can use the form wizard whether your form is based on a table or a query. Queries are preferred though as recordsources.