I have a multi-user database sat on a shared drive. It has upto 10 concurrent users.
I've got two forms REGISTRATION and SPECIAL_NEEDS
both forms use the same underlying query for their data
The Registration form always opens in add mode expecting you to enter a new student. It also has a combo box on it that will
allow you to call up any previously entered student.
This form records basic information only.
Student_number (primary key), Name, DOB, Course, Address, telephone number, reason for appointment, and Archive
The archive field is a yes/no check box
If a student has had no contact for 12 months
then archive = true
Form 2 -- SPECIAL_NEEDS is much larger (6 tabbed pages) but also shows through the data entered on form 1
Usually form 2 opens without any filter. the client is selected from a combo box and all works well.
The combo box on form 2 is populated from a sub query that only shows current students .ie.. archived = false
This keeps the number of current/active records to a minimum and speeds up the whole process.
However. if the student looked up is not in the list then it automatically opens the REGISTRATION where you can look up from
the full list and uncheck the archived box or enter a new record.
What I am trying to do and am having difficulty with is in returning to form 2 and having it open with the currently selected
record from form 1
NO that is not quite true --- I can open form 2 with the current record but then the form is locked with that record... the
filter button on the toolbar is highlighted and you cannot now select another record from the combo box on form 2.
If you click the filter button ei. turn the filter off then you can select from the combo box.
What I want to do is edit the current record and then turn the filter off with code rather than manually.
I assumed that the "on focus" event of the combo box was the logical place to put some code but I this is where I come
I've tried everthing I can think of. I am sure I'm nearly there but getting something wrong. I tried using the
DoCmd.ShowAllRrecords action which does free up the main form but blanks out all values from the combo box at the same
How can I turn of the form filter with code and in which event do I put it?
Hope this all makes sense to you