Loading subform with data from main form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAC - 11 Jun 2007 20:35 GMT

I thought this would do it:

I put this in the before insert of the subform:

Me!txtJobID = [Forms]![frmInvoice]![txtJobID]

frmInvoice is the main form.

What can I do differently to make this work?

Thanks.

Reply to this Message

Marshall Barton - 11 Jun 2007 22:09 GMT

>I thought this would do it:
>
[quoted text clipped - 5 lines]
>
>What can I do differently to make this work?

You could use that code in the BeforeUpdate event, but this
whole exercise would be automatic if you set the subform
control's Link Master/Child Fields properties to the JobID
field.

Signature

Marsh
MVP [MS Access]

Reply to this Message

SAC - 13 Jun 2007 15:06 GMT

Thanks!

I have an Invoice number as the parent field. Is there a way to use both
the Invoice number and the JobID in the Linked Field?

>>I thought this would do it:
>>
[quoted text clipped - 10 lines]
> control's Link Master/Child Fields properties to the JobID
> field.

Reply to this Message

Marshall Barton - 13 Jun 2007 16:25 GMT

Check VBA Help om the LimkMasterFields property for details.

In your case, you could set both of them to something like:
InvoiceNum,JobID
or whatever you real field names are.

Signature

Marsh
MVP [MS Access]

>I have an Invoice number as the parent field. Is there a way to use both
>the Invoice number and the JobID in the Linked Field?
[quoted text clipped - 15 lines]
>> control's Link Master/Child Fields properties to the JobID
>> field.

Reply to this Message

SAC - 13 Jun 2007 20:05 GMT

Thanks! Didn't know I could use multiple fields.

> Check VBA Help om the LimkMasterFields property for details.
>
[quoted text clipped - 20 lines]
>>> control's Link Master/Child Fields properties to the JobID
>>> field.

Reply to this Message

SAC - 13 Jun 2007 20:04 GMT

After I put that into the AfterUpdate event, the cursor won't go to the next
record on a the ds form. It stops on this control as it's the last one on
the form.

What do I need to do?

Thanks!

>>I thought this would do it:
>>
[quoted text clipped - 10 lines]
> control's Link Master/Child Fields properties to the JobID
> field.

Reply to this Message

SAC - 13 Jun 2007 20:10 GMT

Works great after I put in the multiple fields in the link.

Thanks!!

> After I put that into the AfterUpdate event, the cursor won't go to the
> next record on a the ds form. It stops on this control as it's the last
[quoted text clipped - 18 lines]
>> control's Link Master/Child Fields properties to the JobID
>> field.

Reply to this Message