• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Access 2010 - tab form

In Access 2010, I am creating a tab form based off of one table. However, I am unable to split the fields across tabs. That is - the fields appear on all tabs, and when I delete from one tab, it is deleted from all.

I want to have fields 1 - 10 on tab 1. 11 - 20 on tab 2, etc.

Please advise.

Thank you.
0
tahirih
Asked:
tahirih
  • 2
  • 2
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>That is - the fields appear on all tabs,
When you add a control (subform, textbox, whatever) to a tab control, you have to make sure that the tab you want is selected, then move the control.

Otherwise, the control ends up visible on all tabs.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
ok ... here is the drill.

1) drag a control (text box, label, etc.) onto the form somewhere - anywhere.
2) Control X it off the form and into the clipboard
3) From the controls drop down list on the tool bar in the upper left hand corner of Access window, select the *Page* number on the tab that you want do add the control.  You will see a that page on the tab control become selected.
4) Now, hover your mouse over the selected area of that page ... don't click yet ... until you see the mouse pointer turn to a Hand.  
5) keep the mouse in that position, then right click and select Paste.

Your control will now be on the correct page ... and only that page.
0
 
tahirihAuthor Commented:
Cannot find the field list in 3. Thanks.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
tahirihAuthor Commented:
Thank you
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Just curious ... did you attempt my comment as a solution?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes ... Jim's solution should work just as well ...

mx
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now