ac goto problem

[xpun]

Ok here is the situation, I have a form that allows a user to create and edit a customer record. When a user wants to edit a member’s record they have to use the record navigation buttons I have set up to get to the necessary record. This isn’t practical if you have 100 or more records and need to edit record 50 since the record nave progresses sequentially

Dim gt As Long
gt = inputbox("enter the member number you wish to navigate to")
 
    DoCmd.GoToRecord , "customer entry", acGoTo, gt
 

Now what I have now works but this uses record numbers, what I would like to do is use the members id number instead. is this possible.
???

note: findrecord does not work
Any help is greatly appreciated
-xpun access 2003 win xp

[missinglinq]

ADezii gives you three different methods of doing this in his tutorial:

http://www.thescripts.com/forum/thread667899.html

Good Luck!

Linq ;0)>

[xpun]

hmm ok i kinda see where hes going but im not that familiar with dao recordset, how would i implement this into a text box ?

Private Sub Text170_AfterUpdate()
  Dim strCriteria As String
 
  Dim rst As DAO.Recordset
 
  Set rst = Me.RecordsetClone
 
 
 
  strCriteria = "[Membernum] = " & Me![Text170]
 
  rst.FindFirst strCriteria
 
  Me.Bookmark = rst.Bookmark
End Sub
 

this produces a data type mismatch in criteria expression error
dosent make any sence there all text
Sorry for not looking through the tutorial

[missinglinq]

I suspect that the error is caused by the datatype for Membernum being text, in which case Line # 10 needs to be strCriteria = "[Membernum]='" & Me![Text170] & "'"
The code you have would work if Membernum was numeric.

Linq

[xpun]

I suspect that the error is caused by the datatype for Membernum being text, in which case Line # 10 needs to be strCriteria = "[Membernum]='" & Me![Text170] & "'"
The code you have would work if Membernum was numeric.

Linq

AWESOME it works , i was fooling around with that statement because i knew membernum wasent numeric, but couldent get the syntax right.

thanks alot linq
i owe ya one

[missinglinq]

Glad we could help!

Linq ;0)>