By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

One record per tab

P: n/a
I need to create a form with one tab per record. Some items may have
10 tabs and some may have 3. Before I start down this road, is it
possible to do this?

Thanks in advance,
Laura

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Programmatically you can but it will be very messy. You are looking at
a lot of code to create the tabs, display the bound controls (on
separate tabs) and filter a single record for each tab.

Nov 13 '05 #2

P: n/a
I decided to try something. However, it keeps giving me an error on
the 'Set rs = db.OpenRecordset(strQuery)'. It says, Too few
parameters, expected 1. I gave it one. Any ideas as to what is wrong?

Thanks in advance!

Code:

Private Sub Form_Open(Cancel As Integer)
Dim x As Integer
Dim index As Integer
Dim db As Database
Dim rs As Recordset
Dim strQuery As String
Dim strPage As String

Set db = currentdb

x = 1

Do While x < 40
strQuery = "qryPlanOne_" & x
index = x - 1
Set rs = db.OpenRecordset(strQuery)

If Not rs.BOF Then
Me.tabPlans.Pages.Item(index).Visible = True
Else
Me.tabPlans.Pages.Item(index).Visible = False
End If
rs.close
x = x + 1
Loop

Nov 13 '05 #3

P: n/a
"Ozzone" <oz**********@yahoo.com> wrote in
news:11*********************@g47g2000cwa.googlegro ups.com:
Programmatically you can but it will be very messy. You are
looking at a lot of code to create the tabs, display the bound
controls (on separate tabs) and filter a single record for each
tab.


Not really.

Create all the tabs you need and set the .Visible properties of each
page as needed.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.