Hello!<br>
<br>
I have a form that has sveral tabs. On one tab is the usual "input form" 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.
<br>
I have a form that has sveral tabs. On one tab is the usual "input form" 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.