Results 1 to 3 of 3
  1. #1
    drasbach
    Guest

    New field on a form (Access 2000)

    I am new to Access. I decided to add a new field to a table after the table was already created. I now want to add this new field to an existing form. I can't seem to figure it out. The new field does not show up in the field list so I cannot drag and drop it onto the form. I tried a bound field but can't get it to work. Help!

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New field on a form (Access 2000)

    If your new table field is not showing up in the field list for your form it could be because the form is based on a query and the new field needs to be included in the query. In design view for your form check the data source in the properties for your form.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: New field on a form (Access 2000)

    To add to what Judy said, in the future you might want to use a select query of "Select * FROM tablename..... etc.", unless you are deliberately dealing with only a small subset of the table's fields. This makes it easier to add fields to forms (and reports) because the field is already in the recordset. This also becomes significant when you open a form or report and use a WHERE clause in the OpenForm/OpenReport method. You can use the WHERE clause on any field in the query, even if the field isn't actually displayed on the form/report.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •