Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1571
  • Last Modified:

How to Go To Specific record on Access form using VBA on Unbound control

On my Access form, instead of using the "Navigation Buttons" property turned On, I am creating my own controls for Navigation. In order to display the current record that user is on, I have a text box "txtCurrentRecordNo" on the form whose Control Source is set as '=[CurrentRecord]'. In the native Access Record Navigator, if user types in a number in the textbox & presses ENTER, the form moves to that specific record #. I want to replicate the same functionality but my textbox txtCurrentRecordNo does NOT allow me to type anything in it. How do I replicate that functionalty?
0
datasolutionz
Asked:
datasolutionz
  • 3
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Have you seen this (free):

http://www.lebans.com/recnavbuttons.htm

mx
0
 
t_hungateCommented:
I think you are going to have to supply some more info on this one.  What is the primary key of your table?  Does each record have an associated number or autonumber assigned to it?  If so, you don't need to use the =[CurretnRecord] at all.  Just display the primary key, and give that field and after update event to look up and display the fields current value as current record.

TLh
0
 
datasolutionzAuthor Commented:
DatabaseMX - The above solution is good, but I THINK there is a flaw. if user clicks on the NEW record button to start a new record, that button remains disabled even after the user has entered some data on the form. Normally, as soon as any data is entered on a NEW record, that record is no longer new & the NEW record button should no longer be disabled. Any thoughts around solution? I would think that somehow determine if the Form is Dirty...but I dont know how to imlplement that. Your genius thoughts are anticipated :-)
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Haven't looked at that code for a long time.

However, you could use the Form Dirty event to enable the New Record button as soon as the record becomes Dirty.

See attached screen shot.

mx

Capture1.gif
0
 
datasolutionzAuthor Commented:
Thanks MX....that works well!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
No doubt a small oversight on Leban's part :-)

And a good catch on your part !

mx
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now