Show ActiveInactiveAll - New Record on Top in Microsoft Access


	Back to New Record on Top Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Show ActiveInactiveAll

John Rutter

3 years ago

Hi i have set my ProjectListF up to use Live Projects/Closed Projects/All utilising the IsActive check box. I have 2 questions:
1. can i use VBA to save the last button used, as i mostly use the Live Projects?
2. I have also set up search boxes to locate a specific project. when i use the Live Projects/Closed Projects/All search, the search boxes do not work, the first record in the list is selected, is it possible to make the search boxes work, once the Live Projects have been selected?

	John Rutter OP @Reply 3 years ago

	John Rutter OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
How are you coding your search boxes?

	John Rutter OP @Reply 3 years ago

	John Rutter OP @Reply 3 years ago
Hi I have watched the Search Form 2.0 video, and by using SQL I have solved Question 2. So is there away of saving the search for Live Projects when i close the form, so that when i open the form again it only shows the Live Projects, or Closed Projects or All, i.e. whatever the last search was on?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in New Record on Top.

Next Unseen

New Feature: Comment Live View