Hyperlink on "Report" to open corresponding "Form"

[BNagel07]

I have developed an MS Access database for tracking our ECO's (engineering change orders).

In the screen show blow you will see the report that list all our Active ECO's. I would like to Click that object [ECO #] and have it open the form that corresponds to the selected "ECO #"

Form name that I would like to open is [04B - Engineering - Firmware ECO Form F-04B-02]

So far this is what i have.

The above Where Condition is opening a box that I manually have to type in the ECO number and then it opens the correct form.

Below is a snip of the form showing the field control source. [ECO #]

Any assistance is greatly appreciated.

 

[theDBguy]

Hi. I don't use macros, so this is just a guess. Try changing the Where Condition to this and tell us what happens.

="[ECO #]='" & [ECO #] & "'"

 

[BNagel07]

Hi. I don't use macros, so this is just a guess. Try changing the Where Condition to this and tell us what happens.

="[ECO #]='" & [ECO #] & "'"

Works as intended... Thank you for the quick response.

Could you briefly explain that condition so that I can further understand what its actually "doing"?

I'm not the greatest with these commands.

 

[XPS35]

Why do you want to use a report to open a form? Reports are for printing. Use a continuous form with a button to open a detail form.

 

[BNagel07]

Why do you want to use a report to open a form? Reports are for printing. Use a continuous form with a button to open a detail form.

The report view is easier to see each active "ECO" on a single screen and allows the users to click the ECO # and open the form that show further detailed information.

 

[theDBguy]

Works as intended... Thank you for the quick response.

Could you briefly explain that condition so that I can further understand what its actually "doing"?

I'm not the greatest with these commands.

Glad to hear you got it to work.

The Where Condition argument for your situation goes something like: FieldName = SomeValue

We basically constructed that argument by concatenating a string ("FieldName=") with a variable ([ECO #]).

See if this article helps any.

How to build strings in VBA

I promised a member at UtterAcess that I will write a blog about how to build a string in VBA, particularly when constructing a SQL statemen...

thedbguy.blogspot.com