Open Form From Table

[Bill Hand]

Is it possible to open a form from table and have it access a given
record?

I want to be able to query all baseball cards with the last name Jones
and have it open a table. In each record of the table I have a
hyperlink field that opens a form. Now say I have 10 Jones' and I
want the form to open up to Andruw Jones not Chipper Jones. Is this
possible?

This is more of a curiosity question than anything.

Thanks.

Bill

[Reggie]

Bill, It's not possible via a table because the table doesn't have events
associated with it. What you do is design Forms and use the table/queries
as the recordsource for the forms. You can make the forms look just like a
table by setting its default view to datasheet if you like or you can design
it to look like a datasheet by setting it's view to continuous form and
adjust as you like. Now the form has click, double-click etc. events
associated with each record and you can capture those events, determine the
record you are on, and open another form to the record currently selected on
your form etc. Hope this helps!

--
Reggie

----------
"Bill Hand" <wh*****@Yahoo.com> wrote in message
news:20**************************@posting.google.c om...

Is it possible to open a form from table and have it access a given
record?

I want to be able to query all baseball cards with the last name Jones
and have it open a table. In each record of the table I have a
hyperlink field that opens a form. Now say I have 10 Jones' and I
want the form to open up to Andruw Jones not Chipper Jones. Is this
possible?

This is more of a curiosity question than anything.

Thanks.

Bill

[Jason Smith]

Wouldn't it be easier to use a continious form and use a command
button to open the detailed record? It is not good design to open a
form from a table. Users should never have direct access to the
tables of a database. You are just asking for trouble.
wh*****@Yahoo.com (Bill Hand) wrote in message news:<20**************************@posting.google. com>...

Is it possible to open a form from table and have it access a given
record?

I want to be able to query all baseball cards with the last name Jones
and have it open a table. In each record of the table I have a
hyperlink field that opens a form. Now say I have 10 Jones' and I
want the form to open up to Andruw Jones not Chipper Jones. Is this
possible?

This is more of a curiosity question than anything.

Thanks.

Bill