424,066 Members | 2,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,066 IT Pros & Developers. It's quick & easy.

Microsoft Access problems. When clicking on my “go to member” box to scoll down for a

P: 1
Trying to Edit one of my employees database and I’m getting a compile error: Expected End Sub {box}. When I click OK It highlighted :
Expand|Select|Wrap|Line Numbers
  1. Private Sub member_AfterUpdate()
  2. ' Find the record that matches the control
  3. Me.Recordsetclone.findfirst "[social] = '" & Me![member] & "'
  4. Me.Bookmark = Me.Recordsetclone.Bookmark"
I am clueless but love the program when it works right
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,170
Let's start at the beginning with some very basics of using a forum. Never type out things when you can copy/paste them. Errors can creep in and waste a lot of time. I found a very large number of mis-typed stuff here so even when you absolutely must type them - do it properly. Check that it even looks like what you have to transpose.

Now, your code is a complete mess. How much of this is your sloppiness transcribing it is hard to guess, but certainly some of it must be.

We may be lucky. It could be as simple as that a line saying End Sub is actually missing. On the other hand you could have just left that out when you typed out what was in front of you. From the error message you almost copied in I would guess we may be lucky.
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.