Results 1 to 7 of 7
  1. #1
    alyon is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    89

    Non-continuous form

    Is there a way to make a non-continuous form in Access 2007? If so, please help. :]

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Sure, just change the default view property to single form, and make sure you're not forcing it into some other mode when you open it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    alyon is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    89
    No, I did that. Maybe I'm not asking what I want right...
    When you open the form I want it to be just 1, you can't go previous or next, instead of now how it is 1 of 49... but I already have information in my table.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    If you just want to add new records, change the Data Entry property of the form to Yes. If you're opening it from some other form and you want to open it with just a specific record displayed, perhaps this:

    BaldyWeb wherecondition
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    alyon is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    89
    I don't think I'm correctly explaining what I want....

    I'm not really adding information... but I don't want to disable it incase they need to.

    But I have a form it's pretty much made of three different places... each place has a list of people, you pick your person... it fills in the address, phone, etc. in textboxes

    Then you hit the command button and and it makes it all print on an envelope...
    (the phone numbers and such are because it's an easy way for them to obtain their information)

    So I don't need records of this on my form....
    But I do on my table, because I need it generate the information...

    Is this making any sense?
    By the way, I appreciate you trying to help, especially since I don't feel like I'm making any sense.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Nah, I can be dense at times. If you don't want the form to display records, does removing the form's record source and the textbox's control sources do what you want? That would make it unconnected to the table except for whatever you might do in your code.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    alyon is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2011
    Posts
    89
    That would work... except that my combo box looks up values in the table and inserts them in textboxes..... So, then that doesn't work... I think I've decided to leave it the way it is. They'll never know the difference.

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

Similar Threads

  1. Filtering a Continuous Form
    By sbrookebounds in forum Forms
    Replies: 5
    Last Post: 12-14-2010, 11:41 AM
  2. Continuous form problems
    By jclausen in forum Forms
    Replies: 12
    Last Post: 12-08-2010, 04:45 PM
  3. Replies: 1
    Last Post: 07-22-2010, 05:55 AM
  4. Replies: 6
    Last Post: 07-21-2010, 05:25 PM
  5. Continuous Form
    By duckie10 in forum Access
    Replies: 13
    Last Post: 06-09-2009, 11:15 AM

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