problem in unlinked subform

M

Masoud

Actually there is no link between my main form and subform and i want to use
that for updating table. my subform is as a list that should works as a
distribution list.

for more information Record source of subform is one table that I called
tblcc that contain always 6 records.like

cc (primary key) check(yes/no field)
john yes
smith no
martin yes
,
..
..

Record source of main table is one table that I called tbltransmittalNo

Transittalno (primary key)
t-ct-at-0001



now I want when select item in subform it add records to another table that
I called tblccTransmittalNo like below

transmittalNo(primary key) cc (primary key)
t-ct-at-0001 john
t-ct-at-0001 martin

and when I clear check box in the subform it deletes that from
tblcctransmittalNo.

Thanks a lot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top