My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Make new subform record become new tab page
|
|
 Aug 12 2004, 05:20 PM
Post
#1
|
|
|
UtterAccess Member Posts: 34 From: Moab, UT, USA  |
I posted this last week but didn't get any responses so I'm trying again.
I have a situation where a subform contains a lot of info that is too extensive to put into continuous forms without the data entry form getting unruly. I would like to make each new record in this subform display on a page in a tab control. (Plan is to make the max # of pages and keep them invisible until needed.) So the user would be on the main form, enter the first record for the subform on the first tab control page, then click a button to add another record which would make the second tab page visible, enter second record on second page, etc, etc. I've searched this forum, CDMA, and several Access help websites but have found no info about how to go about this. I attached a screenshot that will help visualize what I want. Any thoughts? Thanks in advance! Heather Edited by: hebandgene on 08.12.04. Edited by: hebandgene on 08.12.04. |
 |
 
|
|
Aug 12 2004, 08:08 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 5,244 From: Northern Virginia |
Maybe I am missing something, but why not just make your subform a single form instead of continuous???
I think that what you're going for isn't possible without switching the form to design view (in full view of the user), adding a page (if that's even possible), saving, reopening, then finding the rec you want...in short a bit of a deal-killer, IMHO... Ben |
|
|
|
|
Aug 13 2004, 08:49 AM
Post
#3
|
|
|
UtterAccess Member Posts: 34 From: Moab, UT, USA |
Ben - Wow, I hadn't thought of that. I need to work on it some to see if that will accomplish what I need. Sounds a heck of a lot easier than my grandiose idea of a tabbed form. Will try it out and post back. Thanks!
Heather |
|
|
|
|
Aug 13 2004, 09:48 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 5,244 From: Northern Virginia |
Glad to help out....I have found that half the battle in designing db's is getting a fresh perspective (whether from someone else or on your own) on those issues that are driving you nuts--frequently there's a light bulb out there waiting to go on.
Good luck, and feel free to come back with more questions. Ben |
|
|
|
|
Aug 13 2004, 10:31 AM
Post
#5
|
|
|
UtterAccess Member Posts: 34 From: Moab, UT, USA |
Thanks, Ben, the Access genius. That works just fine for my data entry purposes. I had been goin' to town making continuous subforms that I completely forgot about the function a single form serves. Definitely a lightbulb moment. Thanks!
Heather |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 02:52 PM |