M
marks
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.
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
M
marks
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
M
marks
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