Customize button "goto last record"

[bertenbert]

Hello everybody,

I have created a database for my wife so she can make invoices.

I have:

- table: in which all invoices are numbered as follows:

GF1
GF2
GF3
GF4
PF1
PF2

GF stands for regular invoice and PF stands for pro forma.

- query based on table



- form based on query:

On this form I have the button "record navigation" "goto last record".

When my wife pushes the button, the button returns invoive PF2

Now I would like to create two buttons:

1) a button which returns the last GF invoice

2) a button which returns the last PF invoice

Instead of one button which always returns the last invoice, being a PF invoice.

The goal is thus to customize the VB-code like:

"goto last record which looks like PF.."

Hope I was clear in my question.

Thanks already

[weekend00]

Private Sub Command0_Click()
    me.invoiceNo.setfocus
    DoCmd.FindRecord dmax("invoiceNO","myTable","invoiceNo<'P'")
End Sub
Private Sub Command1_Click()
    me.invoiceNo.setfocus
    DoCmd.FindRecord dmax("invoiceNO","myTable","invoiceNo<'P'")
End Sub

table name: mytable
invoiceNo is the textbox in the form for invoice number.