Shortcut

[AndyShuter]

I hope I explain this right!

I would like to know if it is possible in Access 2002 Pro to be able to list a series of records in a form and then be able to double click the actual record itself to take me into that particular record directly.

I can list the records (by either using a list box or the continuous forms property) - but would find this facility very useful indeed!

Regards

Andy

 

[dcx693]

This is possible. There are many ways to do this. It's easy to use a combo or listbox in the form header for the list of records, and the main portion of the form for the record details.

An easy way to achieve this is to use the Toolbox Wizard thingee (that magic wand that's in the toolbox). Click it first to make sure it's depressed, then click on a combo box or listbox icon, then place it on your form. Choose the last option that says "Find a record on my form based on the value I selected in my list box."

If want to use a form/subform method, that's also quite possible. The technique is not all that different.