Help with Selected Records.

[ShaneBrennan]

I'm writing a program for my college where I'm managing tutor groups. And I want to speed the movement of students from one group to another.

I can copy, using an append query, all students from one group to another, but I want to be able to be more specific and copy only a few students across.

For example when there is a school trip and a few students from group A and some from group B are going on a field trip. Therefore I create a new group called C and copy the selected students from both A and B into C.


This is where I need some Ideas.

I currently have a form giving group info and a sub-form showing all the members of that group. What I want to do is select the records, on the subform, and make a copy of them - where the new copy has the new group code.

Is there a way of a) identifying which records have been selected, using the record selection to the left of the data. If so could someone give me an idea of how to detect it either through a query or VBA code.

or would it be best to create another control on each record called "Selected" and use a query or VBA to copy these?

I would prefer the 1st method of the record selector - I think this would make life a little easier.

Shane Brennan

Shane Brennan

'-----------------------
' ICQ#125948839
' Emails: sab149@icqmail.com
' shanebrennan@postmaster.co.uk
' Personal ICQ Comms. Centre: wwp.icq.com/125948839
'
' Personal WebPage:

http://www.geocities.co.uk/brennansuk

 

[hermanlaksko]

Hi shane
If I were you I would make a table with my groups in and a table to connect the groups and the students (many to many relation) - but maby I misunderstood the Q.

In any case I would have my students and my groups in 2 tables.

 

[ShaneBrennan]

No thats not it.

I already have 3 tables - tblGroups, tblStudents and tblStudentInGroup.

I need to select students from a list then make another copy in tblStudentInGroup with just a different GroupID.

An Append Query works for ALL students, but I need to, well click on individual students and copy just the ones I want, not the rest.

I could do it with a checkbox on each record of the sub-form BUT I really want to use the record selector. This would make the user interface a little more friendly. Shane Brennan

'-----------------------
' ICQ#125948839
' Emails: sab149@icqmail.com
' shanebrennan@postmaster.co.uk
' Personal ICQ Comms. Centre: wwp.icq.com/125948839
'
' Personal WebPage:

http://www.geocities.co.uk/brennansuk