Retieving Specific Records

[Brian Starr]

I have set up a continuous form that shows only a summary of each record.
How would I go about coding a button that is displayed next to each
individual record that would open another form and show the detail of the
record that I selected by clicking on the button? Also, is it possible to
hyperlink to individual records? If so, how would I go about this? Any
help is GREATLY appreciated! Thanks in advance!!!

 

[chris]

You don't need a button on every record, in fact you don't
need a button at all. You can achieve what you want by
double-clicking the record.

Just add code to the form double click event
you will need something like...

dim frm as form

set frm = childformname
frm.filter = "primarykey = " & me.primarykeyfieldname
frm.filteron = true
frm.show

If you feel you would prefer a button, put the above code
in the click event

 

[Albert D. Kallal]

You can use the following:


me.Dirty = False
docmd.Openform "theDetailform",,,"id = " & me.id

I use the above code all the time. Take a look at the following screen shots
where I use the above:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

 

[Brian Starr]

THANKS!!!!