Solved

how to move the cursor with vba on a fom in access 2013 to a specific record

Posted on 2013-05-23
2
747 Views
Last Modified: 2013-05-23
hi

how can i with vba to move the cursor in a form to a record that the "id" field equel 1  and put the cursor on this record (that the id=1) but  on a different filed that called for example CustomerID

something like this

docmd.GoToRecord id=1
customerid.SetFocus
0
Comment
Question by:bill201
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 39192639
me.recordsetclone.findfirst "ID = 1"
if me.recordsetclone.nomatch then
    msgbox "Record not found."
else
    me.bookmark = me.recordsetclone.bookmark
    customerid.setfocus
endif

Open in new window

0
 

Author Closing Comment

by:bill201
ID: 39192652
thanks for your fast and excellent solution
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Starting up a Project

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question