How to open a spicific record from given value of inputbox

[juniepiper27]

Dear Sir,

I want to ask what is the code for Macro Builder in a command button if I want to open a report from the given value of inputbox. I made a command button to open a report but it will ask first the required value from inputbox I put. then it will open the report of specific record from the value I input in the inputbox. please help me for this.. thank you so much...

 

[burrina]

I don't use Macros but here is some code you can put for your command button/OnClickEvent

DoCmd.OpenReport MyReportNameHere, acViewPreview
DoCmd.Close acForm, Me.Name

You will need to of course add the InputBox criteria to your query grid that the Report is based on.


HTH

 

[juniepiper27]

I don't use Macros but here is some code you can put for your command button/OnClickEvent



You will need to of course add the InputBox criteria to your query grid that the Report is based on.


HTH

but how the report will open base on the value I input in the inputbox? can you give me the full code in event value? coz I am not familiar in too much coding that's why I am using macros.. thanks

 

[burrina]

Here is an Example:

DoCmd ReportName, acViewPreview, , _
"PrimaryKey=" & nz(Me.PrimaryKey,0)