Can't assign a value to this object

's Computer Specifications

I'm opening a form from a form and after the cmd.openform command I'm trying
to assign a value toa combo box control on the new form from a text box on
the old form by using:

Forms![frmInvoice]![cboJobId] = [Forms]![frmBookingShows]![txtJobNo]

and I get the error that I can't assign a value to the object.

How can I do this so I can put the value into the new form and then refresh
it so it is as if I lookup it up in the combo box on the new form?

Thanks.

's Computer Specifications

I got it to work by requerying the combo box after I passed the value to it.

"SAC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm opening a form from a form and after the cmd.openform command I'm
> trying to assign a value toa combo box control on the new form from a text
> box on the old form by using:
>
> Forms![frmInvoice]![cboJobId] = [Forms]![frmBookingShows]![txtJobNo]
>
> and I get the error that I can't assign a value to the object.
>
> How can I do this so I can put the value into the new form and then
> refresh it so it is as if I lookup it up in the combo box on the new form?
>
> Thanks.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
You can't assign a value to this object	LAS	Microsoft Access Form Coding	3	27th Aug 2010 02:28 AM
You can't assign a value to this object object".	Adan	Microsoft Access	2	29th Apr 2008 05:13 PM
assign object reference to another object	c_xyTopa	Microsoft C# .NET	1	23rd Aug 2007 05:12 PM
you can't assign a value to this object	=?Utf-8?B?U2FuZHlS?=	Microsoft Access Form Coding	2	28th Feb 2007 02:50 PM
Can't assign a value to object	awm	Microsoft Access Forms	5	26th Nov 2004 07:33 AM