April 8, 2004 at 2:20 pm
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!
April 9, 2004 at 7:37 am
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
April 9, 2004 at 1:47 pm
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.
April 12, 2004 at 6:20 am
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
April 12, 2004 at 6:22 am
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