Enter Records Automatically?

[WalksWithSky]

Hello:

I have a database that tracks meetings for a board of directors and attendance at those meetings, as well as for different committees in the board.

Here's what I would like to do, but am not sure if it's possible. The way it is set up now, you select a committee from one drop down list on the main form. There is a subform which lists the attendence. There is a drop down list on the subform the displays all the members of the committee that was selected on the main form, Then there is a checkbox the user clicks if the person attended the meeting, and an explanation box for an explanation if the person did not attend.

Is it possible that once the committee is selected, the subform automatically populates the records with all the members of the committee -- creating a different record for each member, with only the member's name filled out?

Any help provided is greatly appreciated!

Walks With Sky

 

[Trendsetter]

When you use the check box to indicate that a certain person is a member of a specific commitee - this information must be related in the tables.
This is the information you need to interrogate in order to populate the sub form.
If this is not clear come back!

 

[WalksWithSky]

Hey, Trendsetter:

Thanks for the reply. Yes, the members are linked to the committee. As it is now, the user selects a committee from the main form, and then in the subform, the member combobox is populated with just that committee's members to choose from. The user then has to go and check all the names and whether or not they were present, with each different name on a different record in the subform.

How can I get Access to automatically fill in each committee member in an attendance record without the user having to go through and selecte each member on a new record?

That's where I'm getting tripped up a bit.

 

[Trendsetter]

In the subform which lists the members name you have to have a checkbox that will be linked to the tables to indicate attendance at that meeting.
At the moment it would appear that you have an individual record for each member with a checkbox for attendance there is no reason that this can't be done in the subform with all members showing at once.

 

[WalksWithSky]

Hey, Trendsetter:

Great! That's what I need to know. But how do you do it? How do you get it so that when the committee name is selected, all the members' names show up in the subform, and all the user has to do is click the checkbox if they were present/absent?

Walks With Sky

 

[Trendsetter]

This needs to be done by a developer/programmer and I would suggest the Company or person who built the application in the first place.
There is a reasonable amount of work to be done to make the application perform correctly and no doubt there will be a charge from a professional developer.
If you do not know anybody who can do this work for you come back to me and I will advise you further.