Opening a form by clicking on a record in a table

[BULLDOG253]

Is it possible to click on a field of a specific record of a table in
microsoft access and open a form containing information about that record.
If so how is it done?

Thanks

 

[Rick Brandt]

Is it possible to click on a field of a specific record of a table in
microsoft access and open a form containing information about that
record. If so how is it done?

Thanks

It's possible to open a form from another form, but not from a table. Tables
should never be used for anything after intitial development.

 

[Tom Wickerath]

To add some to Rick's answer, you can create a form in Continuous view, which
looks very similar to a table or query. And, within this form, you can use a
click, or perhaps better yet, the double-click event procedure, to open
another form.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________