Distinguish between multiple selected/unselected subform records

[casey]

Hello all.

I'm experienced in VB, but I'm having trouble referring only to the selected(highlighted) records(rows) on a subform.

I would like to select multiple subform records(rows) and use a recordset to loop through the subform recordset and edit those records that are selected on the subform(leaving all unselected records unchanged). I have most of it figured out, but is it possible to distinguish between multiple selected and unselected subform records?

I hope this is clearly stated. Thanks for any help.

 

[WayneRyan]

Casey,

I've never done that before. Can't you use a listbox to feed a
query? There are examples here:

http://www.access-programmers.co.uk/forums/showthread.php?threadid=49992&highlight=hayley+or+hay

Wayne

 

[casey]

Thanks for your reply, WayneRyan.

I'll look over the test.mdb in more depth. If I can't get a subform to work then I'll definitely try using a listbox control. I have an application that does what I've described previously using a subform. I don't know how it works, but I think it can be done. Thanks again for your help.

I welcome any other thoughts...

 

[casey]

Got it!

Contrary to the many searches I've done on this problem, I think there's a solution to this using the SelTop and SelHeight properties for a form.

Thanks again for the help folks. Here's where I found it in case you're wondering.
http://support.microsoft.com/default.aspx?scid=kb;en-us;208502