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?