Loading subform with data from main form

[SAC]

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.

 

[Marshall Barton]

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?

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.

 

[SAC]

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:

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?

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.

 

[Marshall Barton]

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.
--
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?

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?

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.

 

[SAC]

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:

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?

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.

 

[SAC]

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

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.
--
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?

SAC wrote:

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?


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.

 

[SAC]

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
one on the form.

What do I need to do?

Thanks!

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?

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.