How do I modify existing table and form with new fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added the fields to the table and have set up the skeleton for the
label/text boxes in the form, but the form is not recognizing these new
fields. It is displaying "#Name." How can I get this to work?
 
Set up the skeleton? Sounds like you are doing it the hard way. Don't add
an unbound field, then enter the field's source. That is too many steps.

If your form is based directly on the table (which it should not be) then
simply use the "field list" from the menu and drag the new field to your
form.

If your form is based on a query, then you must first add the new field to
the query, then follow the above step to grab the field from the field list.

Rick B
 
That's the problem...I would use the field list, but the field list is not
showing the new fields that I added to the table. Why is this happening?
 
What is the record source of the form? If it is based on the table, then
the field will be there. If the form is based on a query (most likely) then
you must first fix the query. Go to the form's property box and check the
source.

Rick B
 
You are right! The source is the query...that didn't even occur to me.
However, I have a new problem now--the query has a huge number of fields and
will not allow me to add the new fields. Is there a way to get around this?
 
Never mind, I think I have it now! Thank you so much, this was really
frustrating me. I appreciate your time!!
 
Back
Top