Results 1 to 3 of 3
  1. #1
    annie is offline Novice
    Windows XP Access 97
    Join Date
    May 2010
    Posts
    1

    HELP - i ran a query and shouldnt have

    i have a database of 15,000 magazine subscribers and i ran a query to find out which ones were free subscriptions (i RAN the query instead of just VIEWING it like i should have)... i have a drop down list in my form that has options of what kind of subscriber they are but none are showing up in the drop down list...its blank! -how do i get the subscription types to show up in my drop down list in my form again?? - or i guess what i am asking is if there is a way to undo what my query did?


    please reply to me here or email me at ca_elliott33@yahoo.com

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    It depends on the type of query you "ran" (was it a select query or an action query?), but it seems more likely that you have applied a filter to your form.

    Right-click on your form, and select "Remove Filter/Sort" to see if that helps.

    Cheers,

  3. #3
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Hopefully ConneXion is correct and there was no damage. Looking forward, let this scare coerce you to keeping backups of your important DBs. Redundancy is your friend.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums