Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Go to selected record
If I have a tabular form which shows several records per page which are summaries (via query) of the complete records from a table, is there any way I can select a record in this view (or other method of showing summaried records) and then obtaining the single page view of the more complete record? Ideally could just click or double click into the record row and this would go to the justified form view at the record clicked, or click into the record and press a button to do that.
RE: Go to selected record
You could do this with a bit of VBA code.
In the abcense of that you may be able to create a comand button that pulls the record number you have selected and posts it to a new form, showing all the details you require. Look into the ONClick property in the event section, and see what you come up with. You may need to apply a bit of SQL thinking to get it to work smoothly.
RE: Go to selected record
Is there any easier way, for instance could it be done using a macro?
RE: Go to selected record
Hi Mark
If you have access to the tabular record properties, you could attach a macro that opens a form with the appropriate record detail in it.
However, remember that to create a macro, you have to be manually do each step before you can automate it.
Richard
