By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,583 Members | 594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,583 IT Pros & Developers. It's quick & easy.

Open Form From Table

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.