Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Based Form (2k)

    I have a form based on a query that gets its data from 2 tables. When i run the query by itself, 6000+ records show up. When the form is opened, no data shows up, no records, nothing. I don't know why.. the matching key fields of the 2 tables are linked up together in the query, so the user can edit the non keyfield data.

    why doesn't the form show records? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Query Based Form (2k)

    Open the form in design view.
    Activate the Data tab of the Properties window.
    Make sure that Data Entry is set to No, and that Allow Edits (as well as Allow Additions and Allow Deletions, according to your preferences) is set to Yes.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Based Form (2k)

    yeah I eventually figured that out by trial and error, thanks Hans.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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