minutes design

[Associates]

Hi,

I was trying to create a database for recording meeting minutes that happen
every month . I could manage to come up with tables, forms and reports that
make up the minutes database. However, what concerns me here is every new
minutes is generated from the previous minutes (in another word, sort of a
continuation of the previous minutes). For example, say, we want to add a new
minutes for month #3. When user clicks on "Add minutes", the database will
look up the previous month (in this case, month #2) and pop them up on the
screen for user to edit or modify. I am not sure how to do this.

The following list is the tables I have made up
1. Minutes (minutesID(PK), minutesNo, attendance, minutesDate)
2. Agenda (agendaID(PK), agendaNo, agendaItems, minutesNo(FK))
3.Tasks (taskID(PK), taskNo, taskItems, actioner, minutesNo(FK), agendaNo(FK)
4. SubTasks (staskID(PK), staskNo, staskItems, actioner, minutesNo(FK),
agendaNo(FK), taskNo(FK))

Any help would be greatly appreciated.

Thank you in advance

 

[Arvin Meyer [MVP]]

The database doesn't do anything that you don't tell it to do <grin>

Try adding a new button for a new record. There's even a wizard for it:

Private Sub cmdNew_Click()
On Error GoTo Err_cmdNew_Click

DoCmd.GoToRecord , , acNewRec

Exit_cmdNew_Click:
Exit Sub

Err_cmdNew_Click:
MsgBox Err.Description
Resume Exit_cmdNew_Click

End Sub

 

[Associates]

Thank you Arvin for your reply.

Sorry, I do not think i explained it well.

By using the button wizard for inserting a new record, I will get a complete
blank form - waiting for me to insert data into the relevant textboxes.
However, my question is I want to be able to bring the previous record up on
the form when user clicks on "Add New Minutes". For example, say there are
already a few minutes records in the database and say, the last minutes is
for month #5. When user decides to add a new minutes for month #6, he or she
clicks on "Add New Minutes" button to bring up the form. I would expect the
form filled up with data from the month #5 already. So user can continue to
make some changes on the data and save this as minutes month #6.

Thank you in advance