Need to know value of text box on subform

  • Thread starter Thread starter Judy Ward
  • Start date Start date
J

Judy Ward

I have a main form, frmDSSF, that is used to submit SCRs to a software build.
I display the possible SCRs in a list box, lstSCRs, for the user to select.
I display the selected SCRs in a subform, frmSCRs_for_DSSFs, on frmDSSF (the
subform is based on a table tblSCRs_for_DSSFs). I have the code working for
the user to add an SCR (I insert the required information into
tblSCRs_for_DSSFs and refresh the subform).

I can't figure out how to let the user remove an SCR. I would need to know
which SCR (txtSCR_ID) has the focus in the subform right before they click
the button to remove the SCR. If I know the SCR, then I can delete it from
the table and refresh the subform.

Any suggestions for me?

Thank you,
Judy
 
Why delete? Don't you need history on the software lifecycle?
Add a flag field (Yes/No) for archive and add criteria in your queries to
not pull archived records.
 
Karl,

I actually need to delete. I simplified my example for this forum--I did't
provide all the details. This is simply a submittal form. An SCR that is
removed from one submittal will most likely be included in a later submittal
(or closed as rejected).

Any chance you can help me with the value of a text box on a subform?

Thank you,
Judy
 
Back
Top