troubleshooting Question

Respecify criteria for records in a form

Avatar of peispud
peispudFlag for Canada asked on
Microsoft Access
3 Comments1 Solution397 ViewsLast Modified:

I am using Microsoft Access 2010 and VBA

I want to create a form that acts on "MyTable".

I know how to create a query to restrict the view on "MyTable"   by using "Between" as criteria on the [Date Of Data Entry] field (using the wizard thingy).

By default,  I would like this form to load up showing all the records in "MyTable", (and I have locked it all down).   If the user wishes to edit the records,  then I would like to demand "between date" criteria.

I would like to create a Command Button in VBA  to ask for a new  "Start Date"  & "End Date" and then have the form refresh to display the table with this new criteria.

Thank you for your help
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros