Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Disabling fields with focus

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maury Markowitz - 16 Jul 2007 15:44 GMT
I have a form with several subforms on it. When the main form's record is in
a certain state, I disable the various fields on the form and subform.

However, since the subforms get focus as well as the main form, when I go to
disable them I get an error saying you can't disable the field with focus.

I tried creating a hidden field, but for some reason I couldn't SetFocus to
it.

Is there a "best practice" solution to this?

Maury
Maurice - 16 Jul 2007 17:02 GMT
Don't you have a button on your form? That's where I put the focus in a
situation like this. If you do want to use a hidden control place it under
the button or just place it in the form and set the properties to the color
of the form.

hth
Signature

Maurice Ausum

> I have a form with several subforms on it. When the main form's record is in
> a certain state, I disable the various fields on the form and subform.
[quoted text clipped - 8 lines]
>
> Maury
Maury Markowitz - 16 Jul 2007 17:22 GMT
> Don't you have a button on your form?

Actually, no, the subforms are display only. But I'll add a hidden button
instead, that seems easy enough!

Maury
goode2fox - 26 Sep 2007 16:18 GMT
yup you have the to do that some computers do not work

> > Don't you have a button on your form?
>
> Actually, no, the subforms are display only. But I'll add a hidden button
> instead, that seems easy enough!
>
> Maury
pietlinden@hotmail.com - 16 Jul 2007 17:44 GMT
On Jul 16, 9:44 am, Maury Markowitz
<MauryMarkow...@discussions.microsoft.com> wrote:
> I have a form with several subforms on it. When the main form's record is in
> a certain state, I disable the various fields on the form and subform.
[quoted text clipped - 8 lines]
>
> Maury

You would probably have to setfocus to another control on your form
and then disable whatever you wanted...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.