printing selected reports

[Iain M]

hi guys, can i get a little help.
i'm making a quotation program for a friend.
got almost all working. except the actual printing of the quote!
reports come from access and print readily.
quotes are stored in an access 97 db.
have made a form with a sub-form for each individual quote.
but heres the prob.
I CANNOT GET THESE TO PRINT THE SELECT QUOTE.
i've tried to send a paramemter/variable to
appAccess.DoCmd.OpenForm "CustomerQuote", acNormal, , "Select QuoteId Where !QuoteId = lblquoteid", , acDialog

i've also tried crystal reports (the version on the VB6 cd)
got the design but wont print from vb6.

[Bigley]

Have a look at the thread already running on this forum - 'creating access report from ADO recordset'

[paulw]

Your condition in the OpenForm action is the wrong format. It needs to be a WHERE clause without the preceding 'WHERE'

Hence,

appAccess.DoCmd.OpenForm "CustomerQuote", acNormal, , "QuoteId = '" & lblquoteid, , acDialog

Don't use !QuoteID.

This will act as a filter on the underlying recordset.

Cheers,

P.

[Iain M]

still wont function
get the following error message
'2046' the action or command 'openform' is unavailble