G
Guest
I am new to this and was trying to get the plus marks in a table that open
records in a form. Thank you.
records in a form. Thank you.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
I am new to this and was trying to get the plus marks in a table that open
records in a form. Thank you.
Please explain. "get the plus marks in a table that open records in a
form" is hard to understand. Do you want to display records from two
tables that are in a one-to-many relationship? If so use a Form based
on the main table, and a Subform based on the related table.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
G
Guest
The plus marks on the left side of a table that you can click on and it will
bring up a record from a form.
bring up a record from a form.
J
John Vinson
The plus marks on the left side of a table that you can click on and it will
bring up a record from a form.
You're mistaken. The plus mark will not "bring up a record from a
form". Forms do not contain data, and do not contain "records"; a Form
is a window, a display tool. Tables (and only tables) contain data.
The + is part of Microsoft's "subdatasheet" feature, which makes it a
bit easier to view data from linked tables in table datasheet view.
Since most serious Access users avoid ever using table datasheets for
any purpose other than debugging, many consider this a "misfeature" in
that it encourages misuse of datasheets!
To get it (anyway), open the table in design view and view its
Properties. Change the Subdatasheet property from [None] to [Auto], or
select the name of the related table which you wish to see when you
click the +.
Or, MUCH better, create a Form based on your main table, and use the
Toolbox Wizard to create a Subform based on the related table. This
will give you the same information with much more control and
flexibility.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
G
Guest
Thank you for the help. I appreciate it.
John Vinson said:The plus marks on the left side of a table that you can click on and it will
bring up a record from a form.
You're mistaken. The plus mark will not "bring up a record from a
form". Forms do not contain data, and do not contain "records"; a Form
is a window, a display tool. Tables (and only tables) contain data.
The + is part of Microsoft's "subdatasheet" feature, which makes it a
bit easier to view data from linked tables in table datasheet view.
Since most serious Access users avoid ever using table datasheets for
any purpose other than debugging, many consider this a "misfeature" in
that it encourages misuse of datasheets!
To get it (anyway), open the table in design view and view its
Properties. Change the Subdatasheet property from [None] to [Auto], or
select the name of the related table which you wish to see when you
click the +.
Or, MUCH better, create a Form based on your main table, and use the
Toolbox Wizard to create a Subform based on the related table. This
will give you the same information with much more control and
flexibility.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
?
???
John Vinson said:The plus marks on the left side of a table that you can click on and it will
bring up a record from a form.
You're mistaken. The plus mark will not "bring up a record from a
form". Forms do not contain data, and do not contain "records"; a Form
is a window, a display tool. Tables (and only tables) contain data.
The + is part of Microsoft's "subdatasheet" feature, which makes it a
bit easier to view data from linked tables in table datasheet view.
Since most serious Access users avoid ever using table datasheets for
any purpose other than debugging, many consider this a "misfeature" in
that it encourages misuse of datasheets!
To get it (anyway), open the table in design view and view its
Properties. Change the Subdatasheet property from [None] to [Auto], or
select the name of the related table which you wish to see when you
click the +.
Or, MUCH better, create a Form based on your main table, and use the
Toolbox Wizard to create a Subform based on the related table. This
will give you the same information with much more control and
flexibility.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
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.