Link table/form from a datasheet or table Eplaination inside

[GooGoocluster]

I have seen this done with a program at work but i think they made it in .net

here is what I want to do. I want make a datasheet or table that have like a hyperlink or button that links to a form that whould act as a child table. for example like a detials button on and order form.


this is what a sample row would look like:

JobID| Qty | Type | details
12 34 D (button or Link to corrisponing table)

 

[PHV]

Have a look at the DoCmd.OpenForm method and at OpenArgs

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GooGoocluster]

I dont see anything in the help menu that can help me. do you know if there is a differnt way for me to word this so I can use a search engine?

 

[PHV]

In fact, in the Click event procedure of the button you may call the DoCmd.OpenForm method with 4th parameter set properly for the relation (like "JobID=" & Me!JobID)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GooGoocluster]

I guess I would know what to do with the button when I can get it. but right now I am using a subform in datasheet view to display each JobID. my confusion is how do I place a button on each row that the JobID is located?


Look at this pic.

http://www.lib.monash.edu.au/vl/ausart/images/aart17.gif

is there a way to make a table that has a button in each row like the check button in that picture?