Is it possible to 'Drill Down' in Access?

[Adam Thwaites]

At work I use Kerridge and Access. In Kerridge if you do a search it will
bring up a list of results on a form, like a query, except you can only
select rows, not columns. If you double click on any of these records and it
will open another form with all the customers details on.

Is it possible to do this in MS Access?

--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)

 

[Rick B]

Yes, but you have to build it. In your form, I would add a button in your
detail section and have that button open the form you desire for the current
record.

 

[Adam Thwaites]

How would I display a query inside at table so that I could have that command
button?
--
Adam Thwaites
Access Database Designer
adam.*spamless*[email protected]
Manchester, UK
(I have no access to other sites apart from microsoft.com so posting
external links is no use to me)

 

[Rick B]

You would create a continuous form based on your query. The detail section
would contain the fields you want to show from your query and also a button
with code to open the related form.