A way of finding a specific record

[degras]

I want a way of finding a specific invoice record and showing the record on a form, based on an entered invoice number. Note the invoice number is a field on the invoice table. So far I have made a modal dialog where the user can enter a invoice number, but I don't know what to do next or whether this is the right approach.

[ajetrumpet]

many ways:

the easiest would be to query the table with one param, the invoice number, and bind the form to that qry.

[Rixxe]

Edit:
Or use Adams idea....

[degras]

many ways:

the easiest would be to query the table with one param, the invoice number, and bind the form to that qry.

The problem with that approach is that I lose the ability to navigate through all the reocrds.

[ajetrumpet]

The problem with that approach is that I lose the ability to navigate through all the reocrds.

then use VBA to filter your form, and turn the filter on and off when you need to.

[degras]

then use VBA to filter your form, and turn the filter on and off when you need to.

OK. Do you know what VBA I need to code in the onclick event of the modal dialog?

e.g.

Private Sub CommandOK_Click()
'How to navigate to record with InvoiceNo=Me.InvoiceNo and show on Invoice2 form?
End Sub

[pbaldy]

The simplest solution might be to use the combo box wizard, choosing the third option, "Find a record...". That is if the form is bound to the invoice table.

[ajetrumpet]

OK. Do you know what VBA I need to code in the onclick event of the modal dialog?

e.g.

Private Sub CommandOK_Click()
'How to navigate to record with InvoiceNo=Me.InvoiceNo and show on Invoice2 form?
End Sub

invoice2? as in another form stacked ontop of the search form?

if not, use Paul's answer. didn't think of that.

[degras]

Sorted. This is what I used in the OK button on click event:

DoCmd.OpenForm FormName:="Invoice2", WhereCondition:="[InvoiceNo] = '" & Me!InvoiceNoText & "'"
DoCmd.Close acForm, Me.Name
Forms![Invoice2].SetFocus

I noticed you can turn off the filtering by clicking the button at the bottom of the form.