adding new fields in an existing subform

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

Guest

I need to add a new field to a subform nabed csc extension, in a form called
audit request. I have added the new field everywhere I can think of, in the
table called csc extensions, in the form called csc extension, and even in
the form called csc subform. However, when I open the form audit requests in
design view, and click on the subform to pull down the list of fields, the
new field is not there. Short of deleting the subform and adding it back in
again, is there another way of doing this?
 
Susan,
When adding a new field you need to...
1. Add it to the table
2. Make sure that new field is included in any query behind any form
or report. (If you're using the query design grid, make sure the new field
has been "dragged" onto the grid.)
3. Add that field to your form/s and reports. If, in form design
mode, that new field doesn't show in the "available fields" box, then it
hasn't beeen included in the query behind the form.

In this case, check out your subform query, and make sure you've added
the new field to the returned recordset.
 
Back
Top