Filter removed after re-open a form

G

Guest

Hi,
I have a form showing fields of Departments and its Employees. A combo box is used to filter all records of the Department I select. Then I click a command button, it opens up form2 showing that specific Employee's details (and closes form1). This works fine.

But when I close form2 by clicking a close command button I designed, form1 is reopened, but the filter is now removed. (i.e. form1 is reopened with 1st record showing)

Can I have form1 reopend with filtered records showing as before form2 is opened?
(Becasue form2 is just an additonal info to the user only) Perhaps some code in the AfterUpdate property of close command button in form2?

Many thanks for any help!

Regards,
Sam
 
G

Guest

Sorry, correction to my question:

Perhaps some code in *OnClick" property of the close command button in form2?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter removed after re-opening a form 8
Forms property using varables 2
open form to specific record number 5
Open Form unfiltered 2
Remembering records when leaving a form 1
Open a popup from a modal form in Mousedown event 4
Test if form is open 2
Bookmarking a record in a subform. 4

Top