By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

Losing subform current record after delete

P: n/a
I've got a tab control that drives several things, and I'm running into
a problem.

The user searches for a particular patient using unbound controls, and
a patient subform displays the associated results. When the user
selects the patient they want in the sub form datasheet, this selection
drives the results shown in the other two main tabs of the form, like
patient details and transactions. The problem is, whenever the user
deletes a particular transaction in another tab, I lose the primary key
of the patient they previously selected at startup. Instead, the user
sees the transactions of the first patient in the underlying table.

For my transactions sub form, for example, I make this association as
such:
Me.subfrm_transaction_transactions.Form.Filter = "PATIENT_ID = " &
Me.FRM_SUB_PATIENT.Form!PATIENT_ID

I've created a variable to capture this patient ID, and this remedies
part of the problem, but I'm really hoping there's a more elegant way
to preserve the selected patient in the subform, regardless of any
actions the user makes elsewhere in the main tabs.

Thanks!

Aug 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Any thoughts, folks?

Aug 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.