Multiple record creation through a form

[Graham Daniels]

Hi,

I have a pupil merit database in Access 2003 which staff use to record
merits for pupils. At present my form includes a combo box which allows them
to select the pupil, then tick boxes which they can use to record different
merit categories for that pupil. They then have to click to save the new
record they've created and move on to the next pupil. This is laborious if
they have 6 or 7 pupils to do at once.

They would like to be able to see more than on pupil at a time in the form
and create multiple records at once.

Any thoughts on how I could implement this?

Thanks

Graham

 

[Jeff Boyce]

Graham

Not sure I understand where you expect to derive improved efficiency. If
you must:

1. select a pupil
2. check all that apply

then how do you envision speeding this up?

 

[Graham Daniels]

I hope to get the improved efficiency by allowing them to create multiple
records on the same screen rather than having to, as at present, select
pupil, date, lesson, type of merit etc then save and start again for a
different pupil. Ideally they would be able to selct multiple pupils and
give that group of pupils the smae category of merit by clicking once.


Having thought about it a litle bit more I think a simple datasheet form
with pulldowns will be a starting point.

Graham

 

[Scott M]

Create a query that gets the pupils you want, or just lists them all.
Use the form wizard to build a form showing those records.
Ensure the form is set for 'continuous forms' and not 'single'.
When the form opens, it will list all the pupils in the query, and the check
boxes.

If you need help figuring out how to display only a set number of pupils
that
are selected as you discuss, it will take slightly longer to describe.

Scott

 

[Graham Daniels]

Yes, this shows all the existing records, but I just want to have a form
which has a pull down of pupil names and other fields with tick boxes,
allowing reasonably efficient creation of nultiple records

Thanks

Grahm