Search results

I tried to use that but I can't get what I want out of it. This worked for me. Now how would I get it to search for the next value based on that customer. So if a customer appeared more than once it wouldn't go to just the first record. Dim strFindWhat As String strFindWhat =...

Thanks for the reply. unfortunately that hasn't really helped me :( i've tried another bit of code DoCmd.SearchForRecord acActiveDataObject, , , "[Customer] = " & strFindWhat but this hasn't worked either.

So I have a form which is showing the current record and you can scroll through these and make modifications to them from the form as opposed to using a table. The form has the following fields populated from the main table Customer name (Can appear more than once) Status Date Servers Positions...