Contact not opening on correct id (1 Viewer)

[jnvcdfhj]

Hi all,

I have a customers form and each new customer is given a contact id which starts from 18 and goes up to around 700. The contact id is displayed on the form but cannot be edited or removed to navigate to another record.
In order to flick from record to record i have a quick find drop down which displays all contact names and when selecting the one required will change to that record.

I have noticed on selecting certain records i will select the contact name i require but it will display contact id number 18 on the customers record, i have checked the be of the db and the correct information is there but is not displayed. This only happens on a few records though and there is not a pattern to those records?

Any help would be appreciated.

 

[MajP]

Can you provide the navigation code?

 

[Gasman]

I'd start by walking through the code in the debugger with F8 and inspect the variables.?

 

[jnvcdfhj]

Hi,

Please find attached.

 

[Dreamweaver]

Your converting it to a string but checking for a long


"[ContactID] ='" & Me![Combo439] & "'"

 

[arnelgp]

contactID is a number, right (post #1)

.Findfirst "[ContactID] = " & Nz(Me![combo439], 0)

 

[jnvcdfhj]

I have the following error.

 

[Gasman]

Why have you put that code there?:banghead:

It is meant to go in place of your other FindFirst.

 

[Dreamweaver]

Maybe he should use the wizard to create a combo search

 

[arnelgp]

Private Sub Combo439_AfterUpdate()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
With rs
    .FindFirst "[ContactID] = " & Nz(Me![combo439], 0) 
    If Not .NoMatch Then
        Me.Bookmark = .Bookmark
    End If
End With
Set rs = Nothing
End Sub

 

[jnvcdfhj]

I have tried all the code you have provided and neither is working.

This one .Findfirst "[ContactID] = " & Nz(Me![combo439], 0)

No longer takes me to the first record ever entered on to my db but just remains on the current record i was viewing.

 

[Pat Hartman]

put a stop on the FindFirst line of code and print the value of the Nz() expression to see what you get.