Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Field List Problems (Forms & Reports)

    How do you add a field to the field list on an established form/report?

    Alternativly: How do you create a bound control with a field that is not on the field list?

  2. #2
    Join Date
    May 2004
    Go to the data source of the form or report. If the data source is a table, go to the design view of the table and add the field. If the data source is a query, add the desired field to the query if it is in a table on which the query is based. If it is not add it to the table and then add it to the query. The field will then appear on the field list.

    You cannot add a field to a form or report if it is not on the field list directly. You can create a textbox which uses the dlookup function to lookup a value from a table or query which is not linked to the report or table.

Posting Permissions

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