Results 1 to 5 of 5

From queries and tables to forms?

  1. #1
    Fidycent is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    3

    From queries and tables to forms?


    i dont know if its the right section, but is it possible to bring data from queries and tables to forms?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    10,620
    Yes. You can actually use a Form Wizard to "Bind" a table or query to a Form.
    The wizard will build you a "bound " form automatically with just a few prompts.

  3. #3
    Fidycent is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    3
    Thanks it helped a bit but i mean that i want the info from an query AND an table, or is there a way to get from the query to a table so it will count only as one table not a table and a quarie.?

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    10,620
    A table has a recordsource. That record source can be a table or a query.

    There are a number of videos on youtube related to creating forms in Access 2007

    http://www.youtube.com/watch?v=QbRgO...eature=related

  5. #5
    Fidycent is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    3
    Thanks! many questions to come.

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

Similar Threads

  1. Replies: 10
    Last Post: 07-12-2011, 10:09 PM
  2. Forms and SQL Queries
    By springboardjg in forum Queries
    Replies: 1
    Last Post: 06-07-2011, 05:18 AM
  3. Queries, Forms, Reports..
    By groundhog in forum Access
    Replies: 3
    Last Post: 07-07-2010, 11:30 AM
  4. Help with Queries and forms
    By dcwang3 in forum Access
    Replies: 0
    Last Post: 05-28-2009, 07:00 AM
  5. Replies: 4
    Last Post: 04-01-2009, 07:49 PM

Posting Permissions

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