Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Go To Record on Input

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have a Input Field and a Go botton. The form shows the results of a DAO.QueryDef. The query name is qry_SrchProj.
I want on of two things to happen:

1) User inputs record number that they want to jump on OnAfterUpdate the record is displayed.
2) User inputs record number and then clicks on the GO button, then the record is displayed

I tried to use .Move, but I was unable to get it right.
 
I will re-explain my issue under the Forms Forum, but please respond to this if you know the answer.

Problem restated:
Just like on the Standard Record Navigation control, I want the user to be able to enter the the record number they want to view and then after updating the field, the record is diplayed.
I have created a buttons at the top of the form that work just like Navigation buttons at the bottom. Everything is working correctly, except the "Jump To Record" Box.
 
Use:

DoCmd.GoToRecord acDataForm, formname, acGoTo, RecNum

I was trying to use 10 lines of code, Duh!
 
Look at thread702-120513
Maybe there you can find answer to your question.
Aivars
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top