Retieving Specific Records

  • Thread starter Thread starter Brian Starr
  • Start date Start date
B

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!!!
 
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
 
Back
Top