How to launch a form from a table?

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hello,

I am developing a pretty simple database in Access 2007. Currently it looks
like this
Table:Attorney
Form:Enter Attorney Data
Form:Attornney Details
Report: Attorney By Practice Areas

What i would like is to be able to open Form:Enter Attorney directly from
Table:Attorney. I have seen this in other databases, where if you went to
enter data into a new record on the table a form opened automaticly

Thank You!

P.S. I am very new to Access
 
It doesn't work that way and you wouldn't want it to. You should never allow
users direct access to a table. The user should only ever see forms and
reports. If you allow users direct access to tables you can be sure they
will corrupt the data.

The correct method is to use either an AutoExec macro to launch you main
form or the Access Switchboard or enter the name of the startup form in the
Startup Options.
 
Ok well can you open a 2nd form displaying a specific record, by selecting
that record on a data sheet display form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link to second form for read-only users? Possible???? 4
Searching records though a multi-value look up column 10
Could you keep a straight face in court hearings 5
filling a field in a continuous form with a field from a table 1
Auto Fill Fields based on combo box selection 5
What is the best way to start a new database in Access? 1
Information in a table does not appear on the form 1
filling a control in a continuous form with a field from a table 1

Back
Top