Tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using forms to search, edit and add new records to a table. However
after applying a filter the users would like to have the option of viewing
the results in table format as well in a form.

How can this be done?

How1
 
I am using forms to search, edit and add new records to a table. However
after applying a filter the users would like to have the option of viewing
the results in table format as well in a form.

How can this be done?

How1
Click to expand...

I'd suggest either changing this form, or creating a new form; change the
Default View property from Single to either Datasheet or (my preference)
Continuous. A Continuous Form can be made to look very much like a datasheet
but gives you more control (and the users less - they can't resize or conceal
columns as they can in a datasheet).

John W. Vinson [MVP]
 
Thanks John.

However can you tell me if it is possible for the users to view the search
results on single form and datasheet by having single form on one tab and
datasheet on another tab or is it possible for the user to toggle between
these two formats.
 
Thanks John.

However can you tell me if it is possible for the users to view the search
results on single form and datasheet by having single form on one tab and
datasheet on another tab or is it possible for the user to toggle between
these two formats.
Click to expand...

You could put a Subform (continuous) on a tab page of your single form. I'd
suggest making the subform non-updateable so you don't have conflicts with
both forms trying to edit the data.

John W. Vinson [MVP]
 
John,

I have now created a subform in datasheet view on another tab. However the
subform is not displaying the correct number of records found on the form
view. I suspect it has something to do with the subform function restricting
the number of fields that can be linked between the main form and subform.

Do any suggestions to what I am doing wrong?
 
John,

I have now created a subform in datasheet view on another tab. However the
subform is not displaying the correct number of records found on the form
view. I suspect it has something to do with the subform function restricting
the number of fields that can be linked between the main form and subform.

Do any suggestions to what I am doing wrong?
Click to expand...

Since you don't say anything about the recordsource of either form, nor what
you're using as the master/child link fields, it's a mite difficult to say
what you're doing wrong.

If you want the subform to display all records, simply leave the master/child
link fields blank; it won't filter the subform at all.

To add a new Tab control to a form, use the toolbox wizard to add a new Tab
control to the form. You may want to move existing controls onto the first
page of the tab control - it's a bit tricky to do so! You can't drag the
controls onto it, they'll be "in front" of the tab page, not on it. instead,
select all the controls you want to insert onto the tab page (ctrl-click them
all); type Ctrl-X to cut them to the clipboard; select the *tab* of the
desired page (not the surface but the tab itself, the page should darken);
then type Ctrl-V to paste the controls from the clipboard.

John W. Vinson [MVP]
 
Back
Top