Re: Run Time error 2448, You cannot assign a value to this object !!

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi Douglas,

The line causing the problem is:

Forms!frmMainMenu.frmCustomers_edit!contactID = contactID 'value

When I debug and hover over the error the values are there?

will try your suggestion.

TIA

Les


"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:%23YCJvOvtFHA.2076@xxxxxxxxxxxxxxxxxxxxxxx
> Which line of code is causing the error?
>
> What is frmCustomers_edit: a subform on form frmMainMenu? If so, try
> Forms!frmMainMenu!frmCustomers_edit.Form!contactID
>
> See http://www.mvps.org/access/forms/frm0031.htm at "The Access Web" for
> more about how to refer to Form and Subform properties and controls.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "LJG" <lj_girvan@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:OWEK8VutFHA.2912@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi Guys, any idea why this is not working, and giving me the error?
>>
>> contactID is a number field
>>
>> Dim stDocName As String
>> Dim stLinkCriteria As String
>>
>> stDocName = "frmAdditional_Contacts"
>>
>> stLinkCriteria = "[contactID]=" & Me![contactID]
>> DoCmd.OpenForm stDocName, , , stLinkCriteria
>> Forms!frmMainMenu.frmCustomers_edit!contactID = contactID 'value
>>
>>
>> Many thanks
>>
>> Les
>>
>>
>
>


.



Relevant Pages

  • Run Time error 2448, You cannot assign a value to this object !!
    ... Dim stDocName As String ... Dim stLinkCriteria As String ... Forms!frmMainMenu.frmCustomers_edit!contactID = contactID 'value ...
    (microsoft.public.access.forms)
  • Re: Auto fill existing record, allow new entry
    ... A string is text, as opposed to number, date, yes/no, and a few others. ... The expression you are using for After Update in Combo25 is looking for a record in which ContactID matches the bound column of Combo25, ... You mentioned the text box row source. ...
    (microsoft.public.access.forms)
  • Kinda new and having trouble with SQL stored procedure
    ... private static string ConnectionString ... protected static void AddParamToSQLCmd(SqlCommand sqlCmd, ... ParameterDirection.Input, contactId); ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Truss rod basic Q
    ... I have eyeballed the relief when I fret the low e string at the first ... tune up right after you make the adjustment (to bring it back up to the ... The truss rod is typically 8 or 10/32 thread, ... nut may save it from one day refusing to move smoothly, causing you to ...
    (alt.guitar.beginner)
  • Re: Regarding StlinkCriteria / String Variable
    ... The value of your ContactID is not going to be a string ... > specify the actual field data. ... > How do I code the above line so, the stLinkCriteria will ...
    (microsoft.public.access.formscoding)