Inputting information on one form to obtain related records on other forms

  • Thread starter Thread starter TUANDELIA W via AccessMonster.com
  • Start date Start date
T

TUANDELIA W via AccessMonster.com

I am working on a database and I am trying to get my records to come up right.
When I enter a ss in an unbound combo box if there is a record for that ss
then it will come up. When i push the perform intake button for that same ss
an incorrect record comes up. The record that comes up is a record that is
sorted ascendingly by the intake date which is incorrect. Also, when i push
the begin case button for that same ss from the first form it brings up a
case that is sorted ascendingly by case number which is also incorrect. I am
using recordsets.
 
TUANDELIA W via AccessMonster.com said:
I am working on a database and I am trying to get my records to come up right.
When I enter a ss in an unbound combo box if there is a record for that ss
then it will come up. When i push the perform intake button for that same ss
an incorrect record comes up. The record that comes up is a record that is
sorted ascendingly by the intake date which is incorrect. Also, when i push
the begin case button for that same ss from the first form it brings up a
case that is sorted ascendingly by case number which is also incorrect. I am
using recordsets.

Please post you code for both the buttons. Then some one might be able to
help you with the problem. :)
 
Back
Top