469,127 Members | 1,349 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

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

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
Jan 12 '19 #1
1 1025
NeoPa
32,162 Expert Mod 16PB
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.
Jan 13 '19 #2

Post your reply

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

Similar topics

3 posts views Thread by Andrew Wrigley | last post: by
17 posts views Thread by Pam Ammond | last post: by
1 post views Thread by Duffman | last post: by
8 posts views Thread by reema via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.