Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Viewing (2003)

    I'm sorry for this, but I'm in the process of learning Access:

    I'm working on a purchase order form. In the header I have listed 'where to ship,' 'purchase order #' etc.; in the details, customer ID, requisition name, ship date etc. When I put it into FormView it only shows the header -- no details, no footer. I've looked through the properties list for header and details, both say Always Visible. But I get a blank form.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Viewing (2003)

    Welcome to Woody's Lounge.

    Is your form based on a query? If so, open the query and check whether it allows you to create a new record. If not, it would explain why the detail section of your form is blank. Another explanation would be that you have set the Allow Additions property (in the Data tab of the Properties window for the form) to No.

  3. #3
    New Lounger
    Join Date
    Sep 2006
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Viewing (2003)

    You were right, it is based a query and I can't enter a new record. (Allow Additions was set to Yes)
    How do I change this now?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Viewing (2003)

    It depends on the structure of the query:

    1) Totals queries (using Group By, Sum, Average, Count etc.) are never updateable.
    2) Since crosstab queries are a special kind of totals query, they aren't updateable.
    3) Union queries aren't updateable (if you don't know what a union query is, don't worry about this one)
    4) Queries based on more than one table are only updateable if the tables are linked properly, and if there is a unique key on the link field(s) on the 'one' side of the join.

Posting Permissions

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