Results 1 to 2 of 2
  1. #1
    birpal is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    19

    Retrieving, searching, and inputting data between database and Form?

    Hi, I was wondering if it was possible to create a form that both receives data from a database based on filter (date - also lists that filter as a heading) and allows me to enter data in that very form so I can store it in the database. This form should (if possible) allow me to change the date (or any other filter). In other words when I choose a filter i want data to be retrieved from the database based on that filter. Then (if possible) I wish to add data to that very filter and have it store in both the user form and the database.

    Is this possible? And if so (i'm new to Access, but have used Excel), how would I go about this?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Have you looked into the SubForm control? Also, the combobox control can help to filter datasets. Really, what you are describing is a fundamental advantage of relational databases. So, make sure your data is following rules of normalization. You should strive for Third Normal Form.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-30-2015, 12:58 PM
  2. Replies: 9
    Last Post: 09-01-2014, 02:27 PM
  3. Replies: 3
    Last Post: 07-10-2013, 10:29 AM
  4. Replies: 3
    Last Post: 04-09-2012, 06:05 PM
  5. Replies: 6
    Last Post: 12-14-2011, 07:19 PM

Tags for this Thread

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