D
Dave Hawks
I am using a Subform to allow users to reserve times by selecting their name
from a combo box. To speed up navigation the combobox is based on a query and
when selected the standard parameter input box appears and requests the user
to type in the first initial of their surname.When theydo so and press OK
they are presented with a subset of the full list of names from which they
can select and hence enter their own name.
This works for the first record but if the user moves to the next record
without first closing and reopening the main form, the popup does not appear
but the user is presented with exactly the same subset based on their inital
selection in the parameterbox.
To overcome this I attached the following code to the gotfocus event of the
combobox:-
Me.ActiveControl.Requery
This ensures that everytime the user moves to a new record they are
presented with a fresh parameter box requesting their initial.
The parameter box has two options after entering data "OK" or "Cancel". On
first opening the form the user can select either, but after entering data in
one record and moving to a new record , if they select "Cancel" Access
crashes completely with the message "microsoft access for windows has
encountered a problem and needs to close"
Can anyone suggest why and a potential fix?
from a combo box. To speed up navigation the combobox is based on a query and
when selected the standard parameter input box appears and requests the user
to type in the first initial of their surname.When theydo so and press OK
they are presented with a subset of the full list of names from which they
can select and hence enter their own name.
This works for the first record but if the user moves to the next record
without first closing and reopening the main form, the popup does not appear
but the user is presented with exactly the same subset based on their inital
selection in the parameterbox.
To overcome this I attached the following code to the gotfocus event of the
combobox:-
Me.ActiveControl.Requery
This ensures that everytime the user moves to a new record they are
presented with a fresh parameter box requesting their initial.
The parameter box has two options after entering data "OK" or "Cancel". On
first opening the form the user can select either, but after entering data in
one record and moving to a new record , if they select "Cancel" Access
crashes completely with the message "microsoft access for windows has
encountered a problem and needs to close"
Can anyone suggest why and a potential fix?