Getting the ID used in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travis - 08 Dec 2005 11:53 GMT

If I have a subform within a form, the subform will add each new record
according to the ID that was linked from the main form.

My question is, how do I get that ID for query purposes?

I want to run an action query based on the linked parameter of the
subform, but have no idea how to do it.

Thanks.

Travis

Reply to this Message

Ryan - 08 Dec 2005 13:22 GMT

you get it the same way you would get it off teh main form but you need to
reference the subform

eg
in main form the code would be:

me.frmsubSubform.FORM.blahblahblah

or

me.frmsubSubform.blahblahblah

sorry i cant remember the exact code off hand

> If I have a subform within a form, the subform will add each new record
> according to the ID that was linked from the main form.
[quoted text clipped - 7 lines]
>
> Travis

Reply to this Message

Travis - 09 Dec 2005 15:36 GMT

> you get it the same way you would get it off teh main form but you need to
> reference the subform

Ok, thanks. How do I get it off the main form then? :-)

The setup is a main form with a combo box to find a particular family
group, plus the corresponding group ID (not visible) and group name.
The subform is for entering assets owned by the group, the subform is
in table (e.g. repeating... lots of records) format.

So how do I do that?

Travis

Reply to this Message