Software

Ask something
Discussion Locked

Need Tips on Access Subforms

0 helpful
3 replies

by nsohenick

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am creating a simple database in Access to log in weekly tasks to be printed for weekly meetings. I would like to use a table containing general information of the user and a form to get week ending date. I wan to use a subform to get actual task detail so that the user does not have to enter the week ending date for each task for that week. I have already created both tables and both forms and added the subform to the main form. The first (week) form and subform (tasks) work good. When I go to the second record(week) on the main form and the first new record(task) on the subform, it becomes the same first record(task) of the previous main(week)subform. I hope this explains my dilemma. Please let me know how to fix this or any suggestions on a better way.

Thanks,

Nicole S.

3 replies

by timfox2

It is a little difficult to understand what you are trying to achieve, but it sounds like either:
- your subform is not correctly linked to the main form (most likely problem), or
- your database structure is incorrect (primary and foreign key problems).

To correct main/subform linking problems, it's usually easier for new Access users to use the form's wizards.

If your DB structure is the problem, I can only really guess, but it appears as though you might only require two tables, as follows:

tblMeeting
MeetingID (autoumber)
MeetingDate (date)
WeekEndingDate (date)

tblTask
TaskID (autonumber)
MeetingID (number, foreign key to tblMeeting)
Task (text)

Otherwise, you may find it useful to look at one of the sample databases (eg. Northwind) to see how their main/subform is created and used.

Good luck with your DB.
Tim

This discussion is closed to new replies.