I can't decipher this visual basic code, can anyone help me!

[ThunderBolt]

I need to translate this visual basic code intoc ommon english, sort of like a description of what is goin on at each command. The code is used to go to a record that has the same value as the value selected from the drop down list (a search function on my form really):

89. Private Sub Combo20_AfterUpdate()
90. ' Find the record that matches the control.
91. Dim rs As Object
92.
93. Set rs = Me.Recordset.Clone
94. rs.FindFirst "[Subject Reference Code] = '" & Me! [Combo20] & "'"
95. Me.Bookmark = rs.Bookmark
96. End Sub

Please can anyone help please, thankyou.

Regards,
ThunderBolt

 

[jfgambit]

This looks like someones homework...

If so, I would suggest two things

1. Open the textboxes provided to you for the course and get cracking.

2. If you have a copy of Access use the help files to search for keywords (i.e. FindFirst) to help you better understand the code.

If not...then just use 2.

HTH

 

[ThunderBolt]

I'm docementing my programme, and need to annotate the code. its ok though, ill have a look on help.

 

[jfgambit]

I don't mean to sound like I don't want to help, I'm just confused...if you wrote the code then I have to assume you know what it does. If you used the Access wizard to create the combobox, then apply the questions that were asked by the wizard to help comment the code. You created the combobox to Find something...what was it finding?

HTH

 

[ThunderBolt]

Its ok, i am working it out, i did use a wizard yeah, but i have managed to work most odf it out using the help! Thankyou for your suggestions though