Go to a specific record with a button

[torquay]

Not to sure how to do this.

I have a customer form which I obviously enter customers details on. There are times when we do a small cash sale and want to bring up the customer called "cash sale".

Can i do this with a button? as it is always the same record we use for this purpose.

It sounds very basic but for some reason I can't seem to get it??

Thanks
Kim

 

[pbaldy]

Bring it up on the same form? If you look at the code created by the combo box wizard choosing the third option "Find a record...", you could put that code behind a button and hard code the customer number.

 

[torquay]

Thank you for your help I have tried this and it appears to work fine for me.

Private Sub CashSale_Click()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[CustomerID] = " & (5855)
Me.Bookmark = rs.Bookmark
End Sub

Thanks again
Kim