Tabular Form: Click a record to bring up new form with like data?

[Tasuki]

I have a tabular form, where i rearranged it to look like a table. I added a button so that if they click the button next to the record, it will popup another form with data pertaining to the row clicked.

I'm having problems getting the button to work. How can I make the form come up and have it show only the record clicked?

Thanks for looking,

-T

 

[PHV]

Take a look at all the arguments of the DoCmd.OpenForm method.

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

 

[Tasuki]

Thanks,

I attempted to do it this way, but got confused with all the optional Filters and Wheres, but found out that ...

It seems as though the button wizard can do everything I needed. Create the new button, and make it Open Form and select the criteria with which the form should return.

Thanks again for looking.

-T