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 / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Button on subform

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott - 14 Oct 2005 16:31 GMT
I'm trying to create an application to keep track of client computer
inventory/software.  I have a Parent form (SystemProfiles) that keeps general
company information with buttons that open up forms to keep track of router
and server information.  I also have a subform (Client) that is used to keep
more detailed information on individual computers located at a specific
company location.  The links all seem to be working as expected.  On the
subform, however, I have put a button that is supposed to open up yet another
form (Software) that lists the software kept on a specific client computer.  
This is where the problem comes in.

I get an error message when I press the software button on the subform:
"Object doesn't support this property or method."  Although, in fact, the
form opens, it doesn't want to retain the information I put in there.  I have
attempted some coding so that, if there is no associated Client record for a
company, an ID (ClientID) will be set for use in a new client record.  One
variation of the coding I have used to try to make this work looks like this:
       If Forms![SystemProfiles]![Client]![ClientID] <> [ClientID] Then
           Forms![SystemProfiles]![Client]![ClientID] = [ClientID]
       End If
(Yes, I know the brackets aren't necessary).

I think the error code I'm getting, however, may have to do with trying to
open a form from within a subform through a command button (and not with the
code shown above).  If this assumption is correct, perhaps someone can point
me in the right direction.  Any other suggestions would be more than welcome.
[MVP] S.Clark - 14 Oct 2005 22:35 GMT
You've got one to many bangs(!) in there.

Allowable usages:
forms!frmname!controlname.property
forms!frmname!controlname.methodname

or

Forms!fSubformName.form!controlname.property/method

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

> I'm trying to create an application to keep track of client computer
> inventory/software.  I have a Parent form (SystemProfiles) that keeps
[quoted text clipped - 32 lines]
> me in the right direction.  Any other suggestions would be more than
> welcome.
 
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



©2008 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.