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 Programming / March 2005

Tip: Looking for answers? Try searching our database.

vba code to open filtered form -- Run-time error 2448

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ted - 31 Mar 2005 19:53 GMT
i hava a form in my a2k app'n called "RECIST Disease Evaluation: Nontarget
Lesions" from which i select a value of "Patient Number". there's a cmdbox on
it which launches a macro which opens a form called "Lesions: Nontarget -
Baseline" which has a matching control called "Patient Number" that is linked
to a combobox. currently, i forcing the users to use the combobox to select
the value of "Patient Number" however if i were using it i would prefer to
have the benefit of a prefilled in value of the "Patient Number", Soooooo...

i wrote this small vba code which i placed on the Form Open event prop'y of
the "Lesions: Nontarget - Baseline" form and here's the error message that
ensues:

"You can't assign a value to this object".

pray tell why not, may i ask.

anyone care to help me straighten this out?

it'd be really appreciated.

Private Sub Form_Open(Cancel As Integer)
LAS_EnableSecurity Me
Me.Patient_Number.Value = Forms![RECIST Disease Evaluation: Nontarget
Lesions]![Patient Number]
End Sub
Ted - 31 Mar 2005 20:11 GMT
before i forget, i meant to say "there's a command button on it " not "there
a cmdbox on it ".

> i hava a form in my a2k app'n called "RECIST Disease Evaluation: Nontarget
> Lesions" from which i select a value of "Patient Number". there's a cmdbox on
[quoted text clipped - 21 lines]
> Lesions]![Patient Number]
> End Sub
 
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.