B
Bunky
I have a form with two subforms. The one subform is controled via a button.
In this subform, I have a user field and when it is entered via the operator,
the skill set, the supervisor, and special name that is tied to the user on a
Staff table poplulates very nicely. Now when I close that subform and go to
another record then return to the first record and re-open my subform all my
data is fine except the data from the Staff table that I do not save. I just
want to requery, run SQL, I don't know what to do to get the data for the
user to populate again to the screen.
Example: I am on record one and enter a user id. The Specialist name,
skill, and supervisor populates from the Staff table - all is well. I
navigate away and come back to record one and I only see the user id. What
do I have to do to get it to repopulate?
Thanks in advance for all your help!
Kent
In this subform, I have a user field and when it is entered via the operator,
the skill set, the supervisor, and special name that is tied to the user on a
Staff table poplulates very nicely. Now when I close that subform and go to
another record then return to the first record and re-open my subform all my
data is fine except the data from the Staff table that I do not save. I just
want to requery, run SQL, I don't know what to do to get the data for the
user to populate again to the screen.
Example: I am on record one and enter a user id. The Specialist name,
skill, and supervisor populates from the Staff table - all is well. I
navigate away and come back to record one and I only see the user id. What
do I have to do to get it to repopulate?
Thanks in advance for all your help!
Kent