problem with bound control from form to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I've created a form with combo box whose data list comes from a query. The
form has a subform datasheet where I want to use the Index (ProjNum) from the
query to dispaly results in the Subforms' datasheet based on a Subform query
using that Index.

I've tried using this code on the After Update event, but there is some
error (red text):

Private Sub ProjectNum_AfterUpdate()
'Move to the record selected in the control
Me.RecordsetClone.Findfirst "[ID] = " & Me![ProjectNum] Me.Bookmark =
Me.RecordSetClone.Bookmark
End Sub

The query on the subform is working properly, as it's being limited to the
value in the form's Combo box, that combo box value, however simply will not
update. I should note that this database is built in 2000 format (due to
request). Please help. Thanks in advance.
 
Not sure if your post had everything on the correct lines. If so, then the
problem is the placement of the info:

Private Sub ProjectNum_AfterUpdate()
'Move to the record selected in the control
Me.RecordsetClone.Findfirst "[ID] = " & Me![ProjectNum]
Me.Bookmark = Me.RecordSetClone.Bookmark
End Sub

Your Me.Bookmark was at the end of the previous line.
 
Back
Top