How to open a report from filterized subformquery

[juniepiper27]

Dear Sir,

Another, If I want to open an report from the filterized subform query, what is the conditional Expression for the macro builder to open the filterized record from my subform query. I want that if I click the command button to open a report. I want that, What ever I selected record or what ever I filterized record. it will be the output for the report.

please help me to fix my database...

please find attached the sample pictures of database and what I mean to happened. also attached the given macro builder code.

hoping and waiting for your response...

Thanks & best regard,

 

[llkhoutx]

Remember, Access is event driven. A report cannot be opened from a query.

The report is opened after the query is opened/run.

 

[Jass7869]

And how is that done with the marco..open the report and run the query with one button

 

[llkhoutx]

sub YourButton_Click()

execute your run macro instruction
'then
docmd.openreport "YourReportName"

end sub

 

[Jass7869]

Sorry..new to all this..how do I write code to execute the macro?

 

[llkhoutx]

docmd.runmacro "YourMacroName"

Check out the "command button wizard, it builds a lot of commonly used code.

 

[Jass7869]

I did both with runmacro..is that okay? I have one other question. You look like you know what you are doing and I have not gotten anyone to help with this if you don't mind

 

[llkhoutx]

It's OK, if it works. There's lots of ways to do things.

If your question is relative to this post, ask, otherwise post a new question.

 

[Jass7869]

I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every other field is calculated. A + B = C. I have something in field A and I am putting the input in field B to get teh results in field C. So that's say that I queried for a certain analyst and I get four records. When I input anything into first record the input is in all the records for field B. This is where I am having a problem. I only want to input into the the correrdponding record and not all the records I query. Any ideas?