471,893 Members | 1,532 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 1088
32,470 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
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.