How do I activate a form from a table view

[Guest]

I have a number of tables of data that are veiwed and edited by the user in
the normal table continious view mode, not as forms. When the user is in any
record or field in these tables , I would like to be able to allow them to
perform an action such as "docmd openform ...." based on the content of that
current record. I would locate a command button on our custom toolbar and the
"On click" action would then pick up the current active record they are in
and use the contents of the field to open a form, run a report etc.

What is the best way to collect the contents of the current record from the
table as they are parsing through it?

Thanks in advance

(ps Brisbane is fine & sunny and 26 deg c)

 

[Allen Browne]

Tables can't do that. You need to create a form.
Display the form in Datasheet view so it looks like at table if you wish.

Then in the DblClick event procedure of a text box, you can use the OpenForm
action.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...