I have a table tblCharges that contains 257 of the most common criminal charges.
tblCharges contains the following fields
ID (Long Int--Key)
Charges (Text)
Instructions (hyperlink)
MatterID (Long Int)
I have a multiselect list box in my main form frmEditMatters where the user can select the criminal charges a defendant is charged with.
Very simple it displays the charges in a box by line separation. Wonderful
What I would like to do is for each charge selected in the List Box I want to append the Instruction hyperlink to a separate table tblLegalAuthori ty
tblLegalAuthori ty contains
ID (Long Int--Key)
Description (Text)
LegalAuthority (hyperlink)
MatterID (Long Int)
tbleLegalAuthor ity and tblCharges are each related to tblMatter
the Main Form frmEditMatters also contains a subform of frmlegalauthori ty where the user can hyperlink to legal authorities.
What I have tried to do with DAO is with a Command Button next to the MultiSelect List Box on click populate the tblLegalAuthori ty.LegalAuthori ty hyperlink for that particular Matter with the tblCharges.Inst ruction hyperlink for the charges selected by the user.
So if the user was on Matter Joe Smith and selected Assault and Battery and Criminal Trespass the Instruction hyperlink for those charges would, upon click of the command button, be appended to the tblLegalAuthori ty for Matter Joe Smith.
I have made a complete dogs breakfast out of this and cant seem to get anywhere.
tblCharges contains the following fields
ID (Long Int--Key)
Charges (Text)
Instructions (hyperlink)
MatterID (Long Int)
I have a multiselect list box in my main form frmEditMatters where the user can select the criminal charges a defendant is charged with.
Very simple it displays the charges in a box by line separation. Wonderful
What I would like to do is for each charge selected in the List Box I want to append the Instruction hyperlink to a separate table tblLegalAuthori ty
tblLegalAuthori ty contains
ID (Long Int--Key)
Description (Text)
LegalAuthority (hyperlink)
MatterID (Long Int)
tbleLegalAuthor ity and tblCharges are each related to tblMatter
the Main Form frmEditMatters also contains a subform of frmlegalauthori ty where the user can hyperlink to legal authorities.
What I have tried to do with DAO is with a Command Button next to the MultiSelect List Box on click populate the tblLegalAuthori ty.LegalAuthori ty hyperlink for that particular Matter with the tblCharges.Inst ruction hyperlink for the charges selected by the user.
So if the user was on Matter Joe Smith and selected Assault and Battery and Criminal Trespass the Instruction hyperlink for those charges would, upon click of the command button, be appended to the tblLegalAuthori ty for Matter Joe Smith.
I have made a complete dogs breakfast out of this and cant seem to get anywhere.