Hyperlinking text boxes on Reports to Records in Forms

[linuxson]

Hi

I built a custom app from scratch which generates reports from the records in my database
It lists purchase orders in numerical order (with the purchase order number as the line header), followed by whatever is still outstanding on that order just below it


I would like to make the header linkable to the purchase order in question in my form, basically opening up the exact record for editing once I click on the link
Which is the best way to achieve this?

[ranman256]

You don't use hyperlink...you just open the record

docmd.openform "frmRecord",,,"[id]=" & me.txtID

[linuxson]

Hi RanMan256

Tried your method on the OnClick event of the text box. Gave me a Compile Error: Method of Data member not found
The report that I am trying to link from opens up in a separate window, while the form I want it to link back to is a sub-form inside another one
It's located inside a tabbed form body
Think this could be the reason why?

[June7]

Even though form is already in use and open as a subform, your code should open another instance of the form.

Assume report is open in Report View, otherwise the textbox Click event would not work.

I just tested this and it does work.

[linuxson]

Hi June7

I used a macro before, and this also just opened up a new instance of the subform...which doesn't help me much
I have multiple subforms nested inside a master form which is tabbed. It doesn't help the report opens up a new instance
I need it to occupy and populate the same form as the one I use to compile/edit the record
I included a screenshot

The first jpeg shows the Project Details page where I fill in all the project particulars.
When I click on the "Outstanding" button, it launches the report for the specified project number, showing all outstanding purchase orders
The purchase order numbers on the report need to link back to the purchase order numbers on the "Orders" page
My tables were set up in such a way that the purchase order numbers are unique, so they are never duplicated
I need it to re-populate the empty form with the details of the purchase order number which I clicked on which was on the report

[June7]

Then use SetFocus method to return focus to a form or a subform container control. However, returning to a specific record of a subform is not easy.

[linuxson]

Hence, the thread
I built this db from scratch +-1.5 yrs ago, and can't remember all the finer details I stuck into this project
I am trying to catch up with it again, but so far it has been helping me with my job wonderfully
Its mostly just small tweaks here and there to help streamline it even more that I am trying to achieve
It still works without it, would just be easier linking directly from the report to the form instead of constantly running Ctr+F in the fields

[June7]

Need to know more about the form design. The purchase number textbox is in a subform? Actually looks like it is directly on tab control on main form. Or is this a navigation form/control? I don't like and don't use.

[linuxson]

Hi June

That is correct. The POrders form is located inside the Main form on a tab
Basically, what I need is the textbox value on the report stored into a tmp variable or something (not sure how that works),
return focus to the first tab where the POrders sub-form is located, and then use that temp value to search and return the record in the fields for editing
Basically the same effect you would have if you selected the entry field and basically just did a Ctrl+F and entered the text to search
I want the text box on the report to complete this action when you click on it
I could send you an empty dbase if that would help?

[linuxson]

Well, stripped all the data except for one record (purchase order)
You can test whatever you need to with this
Just hold in Shift when opening the database in order to edit it
If you don't, it launches the file itself

[June7]

Which report is involved - POrderIndex_File? How should I open it? From the navigation pane triggers an input popup for Pers Number.

[linuxson]

Go to the "Expediting" tab and check the number in the "Pers" column
That is the number which you enter into the popup
But before you do that, first go back to the "Orders" page and press Alt+E
This brings up another popup which will need the purchase order number (also found on the "Expediting" page)
It's case sensitive, to rule out typos
The next window it opens will allow you to GRN line items that have been delivered
Uncheck the "Delivered" check, otherwise the order and line item won't show up in the report (as it only shows undelivered line items)
Sorry, I forgot to do that





I must admit, it needs a WHOLE lot more polishing, but it does the job so far

[June7]

I seldom use input popups such as InputBox() because it is hard to validate user entry. I NEVER use input popups in queries. How does case sensitive prevent typos?

Alt+E does nothing.

What does GRN stand for?

Which report is involved?