Results 1 to 3 of 3
  1. #1
    lindak is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2022
    Posts
    2

    Question how do you create an input form from a query?

    I have a database for membership roster to collect name and address and other data. I have another table that contains data for payment of membership dues. My husband started this database for me. And I am trying to learn how to add to it. I have a query and tables that contains information of payment of dues. I want to create an input form to add to the table. I am very new with access. Learning along the way. Any help is appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    easiest way to get started is to highlight the table or query in the navigation window (don't open), then select the create tab if not already done and either click on the form button which creates a basic 'single' form, or the form wizard button and follow the prompts for the type of form you want. Experiment, you can always delete the form if it is not your your liking.

    For many, that is sufficient but once you understand how the form has been constructed from the table/query you can start to modify it by moving/resizing controls, removing those you don't want and adding in new ones or changing say a textbox to a combo

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    The simplest approach is probably to use the form wizard to create a form based on the table. If you only want to use this form for adding records, you can set its Data Entry property to True (Property sheet > Data tab) but the downside is that you would only be able to use that form in one fashion, which is to only add records. That might lead to the newbie approach of a form to add, and a similar form to edit - not good. On top of all that, what you probably need is a main form that displays membership details for one member at a time and a subform that shows dues transactions for that member. If all of that is news to you, I think you should research the web or read a book on Access basics (you don't mention forms in your post, so I'm assuming you're adding records via tables, which is not a good thing beyond initial db design and testing).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 9
    Last Post: 03-05-2021, 09:44 AM
  2. Replies: 1
    Last Post: 10-30-2014, 10:11 AM
  3. Replies: 6
    Last Post: 10-27-2014, 08:05 PM
  4. Replies: 16
    Last Post: 05-04-2014, 09:54 PM
  5. Replies: 8
    Last Post: 12-19-2012, 06:56 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