You Can't Assign A Value To This Object Troubles.

[Stephenson]

Hello all,

I'm using the following code to open a single form from a continuous form.

Private Sub tboHomeVendorID_DblClick(Cancel As Integer)
     DoCmd.OpenForm "frmVendor", , , , acFormAdd, acDialog, Me.VendorID
End Sub

And

Private Sub Form_Current()   
    If Me.NewRecord Then
          Me.tboVendorID = Me.OpenArgs
    End If
End Sub

Using this I get the error "You Can't Assign A Value To This Object"

This is very frustrating because I'm currently using this same code to with other forms successfully.
If I alter the code to open another form then it will work, therefore I have narrowed down that my problem is with frmVendor. My form is set to allow edits and there are no input masks.

I've also created a new form with the same record source, tblVendor and have had no luck there either. tblVendor appears to be setup the same as my other tables so I'm at a complete loss as to where my problem is.

Please oh please let me know if you see the error in my ways.

Thank you for looking.

[pbaldy]

Can you manually enter a value in that textbox? Can you attach the db here?

[davegri]

Is tboVendorID bound to an autonumber field? You can't assign values to them. That's why they're 'auto', and take care of themselves.

[Stephenson]

Is tboVendorID bound to an autonumber field? You can't assign values to them. That's why they're 'auto', and take care of themselves.

Davegri, you've hit the nail on the head here. I did not realize that, but that is exactly what I was trying to do.

Now knowing this, how can I call my single for to the same record I double click on in my continuous form?

Thank you for the help.

[pbaldy]

Like this?

BaldyWeb wherecondition

[Stephenson]

GREAT!

Thank you for the help. I'll put this to work.

Have a great day.

[pbaldy]

Happy to help!