Printing current record

[Bentleybelle]

This could go in forms or reports, I think but:

I have a database which I am developing over time as I see ways of improving it and as I learn bits of vba. My current problem relates to invoicing (that I have probably created for myself!): I currently have two invoice report layouts because of different invoicing addresses.

I now want to add a cmd button to my invoice entry form that will firstly preview, then print the current record. I found elsewhere in the forum a way of previewing just the current record by way of specifying in the underlying qry the ClientID so that it selects the record displayed on the form.

I have this line of code which then previews the invoice:

DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview

This does not take account, though of the different invoice layouts.
I think strictly speaking I should only have one invoice report, but what I want to say is this:

If the client is a private client, then preview rptInvoicePrivate,
Else preview rptInvoiceLocumWork

I have tried entering this code that does not work

If SolicitorID = "1" Then
DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview
Else
DoCmd.OpenReport "rptInvoiceLocumWork", acViewPreview
End If

It comes back with a message that SolicitorID is not defined, but I have included Option Explicit.

Any help please

 

[ColinEssex]

The 1 is a number. Don't use the "" - only use "" (quotes) for text.

Col