From Table to Form

[DavidMcArthur]

Hello

Im sorry in advance if this has been posted and answered somewhere else on the forum.



I have a table with plant that has broken down (based on a query where one of the categories from a drop down box is "Needed Repaired"). So this shows me all the plant that is broken. I would like to have a hyperlink from each of the rows that when you click on it then it will open a form with all that specific information for the repair guy to complete the rest of the information, change the Needing Repaired drop down to Fixed then the item wont show up in the table again.

Does this make sense?

I hope so. Its bugging me because i dont know how to do it. It may be the simplest thing but with your expertise I'm sure i'll understand in no time!!!

[CJ_London]

you shouldn't need a hyperlink, just the following code

docmd.openform "nameofrepairinfoform",,,"PlantPK=" & me.PlantPK

change names of nameofrepairinfoform and PlantPK to the name of your form and the name of the primary key you are using

where you put it depends on your form design - common locations are in the onclick event of a button or a control which displays a name (such as your plant name)

[DavidMcArthur]

Thank you! That was perfect. Its so easy to do... when you know the right code!