How to open a report from filterized subformquery

juniepiper27

Registered User.
Local time
Today, 12:38
Joined
Sep 24, 2014
Messages
49
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,

SAMPLE-1.jpg

SAMPLE-2.jpg

SAMPLE-3.jpg

macro builder code for open report.jpg
 
Remember, Access is event driven. A report cannot be opened from a query.

The report is opened after the query is opened/run.
 
And how is that done with the marco..open the report and run the query with one button
 
sub YourButton_Click()

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

end sub
 
Sorry..new to all this..how do I write code to execute the macro?
 
docmd.runmacro "YourMacroName"

Check out the "command button wizard, it builds a lot of commonly used code.
 
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
 
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.
 
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?
 

Users who are viewing this thread

Back
Top Bottom