D
David
Hello all,
I have a list box on the left side of the page and a
subform that queries table 1 on the right side.
If the user double clicks an item on the list box, it adds
it to table1 and displays it in the subform/query to the
right. The query displays fields from multiple tables.
The common link (relationship) between the list box,
table1 and the query is Field2. I want to be able to
delete the record in table1 when the user double clicks
the record in the subform/query. I believe I want to use
the dlookup command and then docmd.delete recordset. But
I don't know how to begin to make that happen.
Can someone help me or point me to a sample database that
demonstrates this combination of functions?
Thank you for your help,
David
I have a list box on the left side of the page and a
subform that queries table 1 on the right side.
If the user double clicks an item on the list box, it adds
it to table1 and displays it in the subform/query to the
right. The query displays fields from multiple tables.
The common link (relationship) between the list box,
table1 and the query is Field2. I want to be able to
delete the record in table1 when the user double clicks
the record in the subform/query. I believe I want to use
the dlookup command and then docmd.delete recordset. But
I don't know how to begin to make that happen.
Can someone help me or point me to a sample database that
demonstrates this combination of functions?
Thank you for your help,
David