Trying to put job# picked in combo box from Main form into Subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

babs - 07 Jul 2007 04:08 GMT

Below is the code I put in and there is an erro

Me![Job] = Forms!frmljncCleaning!cbojoblocautonum.Column(1)

I am trying to automatically fill in the job(number) in the subform based
off of what is selected in the combo box of the main form - the job number is
the second field in the combo box.

I am sure sytax is wrong somewhere - just not sure where??

Thanks,
Barb

Reply to this Message

SteveM - 07 Jul 2007 12:50 GMT

What error are you getting?
Where is this line of code?

If it is in your subform, try:
Me!Job = Parent.cbojoblocautonum.Column(1)

Steve

> Below is the code I put in and there is an erro
>
[quoted text clipped - 8 lines]
> Thanks,
> Barb

Reply to this Message

babs - 07 Jul 2007 15:10 GMT

No I am getting the below error with the suggested code

Invalid reference to the parent property

The combo box of jobsloacautonum is actually an unbound combo box the only
thing bound on the main form is the date. Would like to keep it unbound
since everything pretty much working just need to know how to reference it to
get the job automatically put into the subform job field.

Thanks again,
Barb

> What error are you getting?
> Where is this line of code?
[quoted text clipped - 16 lines]
> > Thanks,
> > Barb

Reply to this Message