(This is my first time to this forum, hope I can post about help for VBA code here - sorry if I'm breaking etiquette; don't hate me.)

Hi,

I've got a database in Access that's been giving me grief for awhile. There is a combo box in my main form. I only have 5 records in my main form; one for each of the years five main goals. I want this main form locked at those five records so that the main form can never be manipulated (how?).
Also, I want it setup so that the user can click a combo box with all five goals listed, pick one, and the subform refreshes with that goal's subInfo based on the goal picked. I've managed to make some bookmark code work (I think). Now I just need to figure out how to synchronize it with the subform - So the user can click between the goals in the combobox freely and have the subform update.
I need it so that the user pops up the form, has 5 goals to chose from, picks one, and the subform is switched to the appropriate spot. I've got a one-to-many relationship setup between the main form and subform because each goal may have about 20 subgoals within it.
I've got an After_Update setup on the goal Combobox, and I've got an On_Current in the subform that I'm trying to link with the main form so they synchronize, but I'm having some problems.

The code I've put in the main form is this:

Private Sub Goalbox_AfterUpdate()

Dim rst As Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "Goals = '" & Me.Goalbox.Value & "'"

If rst.NoMatch Then
Beep
Else
Me.Bookmark = rst.Bookmark
End If

rst.Close

Set rst = Nothing
End Sub

................. This appears to be working allright and gives me a bookmark. However; I dont know what to do with this bookmark when synchronizing with my subform. I think I need to put some code in the On_Current section of my subform.
Any ideas or anyone have some code handy that I could edit that might work; thanks for your help!

-Josh