PC Review


Reply
Thread Tools Rate Thread

Can't assign a value to this object

 
 
SAC
Guest
Posts: n/a
 
      17th Dec 2006
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.


 
Reply With Quote
 
 
 
 
SAC
Guest
Posts: n/a
 
      18th Dec 2006
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.
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:35 PM.