J
Jim Tanis
I have three tables, tbl1, tbl2, tbl3
tbl1 has three fields, one is autonumber primary key.
tbl2, tbl3 have one field each that relates to tbl1,ID field
I have designed an append query that duplicates the record from tbl1, that
the ID is the same as the relatedID displayed on tbl's2 form
(forms!tbl2!relatedID as criteria in the ID column of tbl1).
What I want to do is that I want to make the criterium to take its value
from the active form's control named relatedID, so as whichever form (of
tables 2,3) is open, the query appends the record that has the value of the
opened form's control named relatedID.
what is the expression I should use?
forms(activeform)![relatedID] doesn't work.
thanx in advance
tbl1 has three fields, one is autonumber primary key.
tbl2, tbl3 have one field each that relates to tbl1,ID field
I have designed an append query that duplicates the record from tbl1, that
the ID is the same as the relatedID displayed on tbl's2 form
(forms!tbl2!relatedID as criteria in the ID column of tbl1).
What I want to do is that I want to make the criterium to take its value
from the active form's control named relatedID, so as whichever form (of
tables 2,3) is open, the query appends the record that has the value of the
opened form's control named relatedID.
what is the expression I should use?
forms(activeform)![relatedID] doesn't work.
thanx in advance