? Add New field from table to form?

[Guest]

I saw that this question has been posted and answered twice, but I still
could not get it to work properly. I am trying to select two new field that
I added to my backend database from the properties form control source. The
two new field are not listed and I keep receiving a #Name? error. The fields
do appear in the both the back end and front end tables, but not in the
properties for the text box. I used ALT F11 to read the source from VB but I
do not know what I need to change. Any help is greatly appreciated. Thank
you!

 

[Gina Whipp]

Sounds like you need to add the fields to your query from which your form is
based.

 

[Guest]

Thanks for the quick reply, but i still do not understand. The guy who
created this database is no longer here. This is a huge database and it has
plenty of queries, forms, reports, and tables. How can I tell which query
the form is based?

 

[Gina Whipp]

Little tricky to answer now... It's not your database??? Not normal
procedure to tell someone how to 'break' into someones code.

 

[Guest]

Oh ok. That is fine. It is the company's database, but the guy who created
it is no longer here and I have been instructed to add two new fields to one
of the forms. It is ok. I will talk with our IT department and hopefully
they will be able to help. Thanks anyway.

 

[Guest]

I reread one of the posts from earlier and I found my answer. It works!
Thank you.

 

[Guest]

Refer to "how do i add a new field from a table to a form" 3/7/05