G
Guest
I have a form with several combo boxes (6 total, 2 cascading) allowing a user
to choose how they will find a clients information. ie: select client by last
name, select client by ss#, select client by Client ID, select client by
Birth Date.
After the client is selected a subform shows all of their transactions and
you can select to edit a previous transaction or add a new transaction.
When you edit or add a transaction a new form is opened and when you close
that form you are back at the select client form.
Everything seems to work fine for about 100 entries, then my combo boxes
loose their minds and you click on Sally Smith and the record returned is Jim
Holliday.
Nothing makes sense until I delete all of the combo box selections and press
the remove filter/sort button; Then the combo boxes work fine again for
another 100 or so records.
Is there a way that when the transaction form closes all information and
filters on the select client form would be purged?
Any help would be appreciated.
Thanks,
Jennifer
to choose how they will find a clients information. ie: select client by last
name, select client by ss#, select client by Client ID, select client by
Birth Date.
After the client is selected a subform shows all of their transactions and
you can select to edit a previous transaction or add a new transaction.
When you edit or add a transaction a new form is opened and when you close
that form you are back at the select client form.
Everything seems to work fine for about 100 entries, then my combo boxes
loose their minds and you click on Sally Smith and the record returned is Jim
Holliday.
Nothing makes sense until I delete all of the combo box selections and press
the remove filter/sort button; Then the combo boxes work fine again for
another 100 or so records.
Is there a way that when the transaction form closes all information and
filters on the select client form would be purged?
Any help would be appreciated.
Thanks,
Jennifer