Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 8th, 2003, 10:57 PM
Registered User
Join Date: Dec 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access help, subform on a cont. form

I'm a fairly inexperienced access user so thanks in advance for your help.

I need to put a subform on an existing continuous form. If you can answer that or give me any tips with just that, then don't bother reading on. The rest is background and sort of the basics of what I am trying to do.

Basically what I've done is designed a database to keep track of daily logs within a busy department because I need the searchability and multiple user access you get from a database (before I did this everything was kept in a separate word.doc for EACH day...talk about a nightmare to search through)

I have two tables that I need to enter data on the same form. tblDailyLog is many records for one day on a continuous form for easy browsing. tblDutyLog is three entries that are static for the entire day (duty manager names for each of three shifts)

The way I have arranged everything is to have users enter data on a form called frmDailyLog The form is a continuous form so users can see other entries as they are making their own. A report is generated at the end of the day that is then published. Now I need to add a new feature...a section of the report that lists which duty manager was on duty during the three shifts.

I initially added the field to frmDailyLog but then realized that was no good because I had 30 entries with the same date in frmDailyLog and the three names of shift managers are static for the entire date. Next I tried a separate table called tblDutyLog. This has three fields (one for each shift), a date field and an ID field. This will work bu I need to be able to enter the data in both tables from one form. I haven't been able to do it.

Sorry this got so long...hope you can help.
Old December 28th, 2003, 05:44 PM
Authorized User
Join Date: Oct 2003
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts

Hi akwormy,
First of all, Access won't let you create a main form as a continuous form if it has a subform (in any mode). The main form must be in single form mode and again the subform can be in any mode.
Maybe you can use a list box (with the fields of the main form) actually on the main form just for reference?
Good Luck!

Similar Threads
Thread Thread Starter Forum Replies Last Post
set form on subform gigi79 Access 2 May 23rd, 2006 03:08 PM
Open a subform from a form Vision G Access 5 May 13th, 2006 04:21 AM
Cant print when the form become subform yikchin Access 6 November 22nd, 2005 10:22 PM
Test for completeness of last record in cont. form markw707 Access 0 November 19th, 2004 10:55 AM
form/subform problem chacquard Access VBA 5 June 21st, 2004 10:45 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.