Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datasheet view in forms

Status
Not open for further replies.

kevink

Programmer
Nov 23, 1999
53
IE
Hello!<br>
<br>
I have a form that has sveral tabs. On one tab is the usual &quot;input form&quot; and what I'd like to do is to create another tab that shows all the current records in a datasheet, so that when a user selects a name and switches back to the input form, that persons details appears. It's very similar to the way in which Lotus Approach works.<br>
<br>
However, when I do this in Access, the datasheet view only shows details for the current record and doesn't list all records. Any way around this?<br>
<br>
Thanks,<br>
<br>
Kevin.
 
Yes,<br>
First of all you have to understand that a TAB is setting on top of a main form so it can only see the data of it. Main forms can only see one record at a time.<br>
Try this add a Subform to the TAB that you want.<br>
A subform will show more than one record in the same recordset or a different recordset. And you can link it or not to the recordset of the main form.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top