A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Control can't be edited..." in sub-form



 
 
Thread Tools Display Modes
  #1  
Old May 23rd, 2006, 09:24 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default "Control can't be edited..." in sub-form

I have asked about this in another thread but have decided to repost to give
my problem more exposure.

I am trying to create a combo box in a sub-form and have been referred to
this web page regarding this matter but I haven't got very far.

http://www.mvps.org/access/forms/frm0031.htm

My main form is called "employee", the name of the subform is called "dept"
and the control source for the combo box is also called "dept".

At the moment I have the following in the controlsource:

=Me!dept.Form!dept

Is there something I should know?
  #2  
Old May 23rd, 2006, 10:11 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default "Control can't be edited..." in sub-form

Somehow, I can now select an option in the sub-form (though I'm not sure what
I've done!)

but I now have the message:

"The object doesn't contain the automation object 'Week'. You tried to run a
visual basic procedure to set a property or method for an object. However,
the component doesn't make the property or method available for automation
operations".

I have read in another thread about using other applications. I am not doing
this. I am not running any visual basic procedures either.

'week' is a text-box in another sub-form.

Any ideas? thanks!

"scubadiver" wrote:

I have asked about this in another thread but have decided to repost to give
my problem more exposure.

I am trying to create a combo box in a sub-form and have been referred to
this web page regarding this matter but I haven't got very far.

http://www.mvps.org/access/forms/frm0031.htm

My main form is called "employee", the name of the subform is called "dept"
and the control source for the combo box is also called "dept".

At the moment I have the following in the controlsource:

=Me!dept.Form!dept

Is there something I should know?

  #3  
Old May 23rd, 2006, 11:53 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default "Control can't be edited..." in sub-form

IGNORE THIS THREAD

It seems I've now sorted it all out.








"scubadiver" wrote:

I have asked about this in another thread but have decided to repost to give
my problem more exposure.

I am trying to create a combo box in a sub-form and have been referred to
this web page regarding this matter but I haven't got very far.

http://www.mvps.org/access/forms/frm0031.htm

My main form is called "employee", the name of the subform is called "dept"
and the control source for the combo box is also called "dept".

At the moment I have the following in the controlsource:

=Me!dept.Form!dept

Is there something I should know?

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Controls disappear from Data Entry form Paul Ponzelli Using Forms 10 February 26th, 2006 05:51 AM
Customers- Contracts form problem GL Using Forms 10 February 7th, 2006 04:05 PM
Date range on reports Mark_Milly Setting Up & Running Reports 10 January 19th, 2006 03:49 PM
Move feild entries from form to form using global variables JackCGW General Discussion 11 November 14th, 2005 05:22 AM
Tell if Form is a Dialog Alex Using Forms 7 August 30th, 2005 06:22 PM


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.