[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2007 goto specific record while in the form

Posted on 2010-09-13
4
Medium Priority
?
632 Views
Last Modified: 2012-05-10
Howdy all,

Silly one:  I have a form onto of a table and I want to be able to use a "go to" to jump to a specific record. number.

The form is called "frm log" and the record I want to use is the unique log number "ID", I have created a field on the form to add the record number I want to jump too and a button, but dont seem to be able to get the VB behind the button to work.

All help greatfuly received.
0
Comment
Question by:Smartin
4 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 33661062
Smartin,

In the Click Event of your button, you may try and copy the code below:

Me.Filter = "[ID]=" & Nz(Me.[txtField],0) & ""
Me..FilterOn = True

Sincerely,

Ed

0
 

Accepted Solution

by:
Smartin earned 0 total points
ID: 33661121
Amazing - spot on!!!

Many thanks...
0
 
LVL 6

Expert Comment

by:JVWC
ID: 33661134
If you use the wizard to add a combobox and select the option to create one that finds a record in your form, then add the fields you want, should do it.

Cheers
JC
0
 
LVL 9

Expert Comment

by:borki
ID: 33661150
If you don't want to use a filter check out this solution:

 Dim rs As DAO.RecordSet

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[ID] = '" & Nz(Me.[txtField],0) & "'"
    Me.Bookmark = rs.Bookmark
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

873 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