Me.Bookmark=rs.Bookmark

  • When I click on my combo box I receive this MS Visual Basic message:

    Run-time error '3200':

    The record cannot be delelted or changed because the table 'Case Information' includes related records.

    When I debugg I receive:

    Me.Bookmark = rs.Bookmark

    Help!

  • What does your code look like?  Is this in Access VBA or VBScript in ASP?

    Just some initial thoughts...

    1)  Bookmark is probably a reserved keyword

    2)  Set your combo box rowsource = recordset

    3)  or use AddItem to loop through the recordset

  • If this is Access:  First what event is the me.bookmark placed in.  Second what is the rs variable set to.  Third are you trying to set the bookmark based on what is selected in the combo box in order to return the record that was selected by the user.

  • Additional Information:

    Access 2002 - Comb Box Information:

    Find a record on my form based on the value I selected in my combo box.

    Control Source: Case#

    After Update: [Event Procedure]

    MS Visual Basic Code

    Private Sub Combo77_AfterUpdate()

        ' Find the record that matches the control.

        Dim rs As Object

        Set rs = Me.Recordset.Clone

        rs.FindFirst "[Case#] = '" & Me![Combo77] & "'"

        If Not rs.EOF Then Me.Bookmark = rs.Bookmark

    End Sub

     

  • In Access, a combo box with this statement is attempting to navigate to a particular record by synchronizing the form with the underlying recordset.  There is an Access combo box wizard that can do this correctly, so if you absolutely can't get this to compile, build a new combo box using the wizard in place of the old one.



    Dana
    Connecticut, USA
    Dana

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply