Question Go to record based on value in textbox. (1 Viewer)

behedwin · Jun 24, 2018

I want a textbox where i can type in a ID number.
When i type in the number, i want to go to that record on my form.

I have looked at GoToRecord.
But i dont understand how to get it to work....

How should the code look like?

Go to record based on value in textbox.

June7 · Jun 24, 2018

GoToRecord would need a record number - this is the sequence number from the current dataset of the form, not the primary key ID.

Try using FindRecord command instead.

bastanu · Jun 24, 2018

Or better yet use a combo box (instead of the text box) and its built in navigation wizard.
https://support.office.com/en-us/ar...m-a-list-e3ed7711-433a-4931-9cab-b0f71a90c329

Cheers,
Vlad

behedwin · Jun 24, 2018

June7 said:
GoToRecord would need a record number - this is the sequence number from the current dataset of the form, not the primary key ID.

Try using FindRecord command instead.

Ok, ill google on findrecord. Any idea how the code would look like?

Gasman · Jun 24, 2018

I'd probably use FindFirst

https://msdn.microsoft.com/en-us/library/office/ff194787.aspx

behedwin · Jun 24, 2018

ok, im a bit new to this vba so just googling around makes my head hurt.

If textbox value is 4 then go to record with ID 4....
how do i do that with either findfirst or findrecord?

Gasman · Jun 24, 2018

Here is something I use to go back to the record I was on after a requery.
I am saving the autonumber key and then using that to locate the record again.

FWIW the MS example shows exactly how to use it as well.?

Code:

Private Sub cmdRequery_Click()
    Dim lngId As Long
    Dim strCriteria As String
    
    ' Save record so requery on subform will pick up all last record written
    If Me.Dirty Then Me.Dirty = False
    lngId = Me.ID
    Me.Requery
    strCriteria = "ID=" & lngId
    ' Go back to record we were on
    Me.Recordset.FindFirst strCriteria

End Sub

HTH

behedwin · Jun 24, 2018

Yes, that worked.

Using it on the "on current" event and when i change record or go to a new record... everything seems to update accordingly.

thanks.

Question Go to record based on value in textbox. (1 Viewer)

behedwin

New member

June7

AWF VIP

bastanu

AWF VIP

behedwin

New member

Gasman

Enthusiastic Amateur

behedwin

New member

Gasman

Enthusiastic Amateur

behedwin

New member

Similar threads

Users who are viewing this thread