List Selected Rows in Subform

[thegentleman]

I have a subform displaying a datasheet something like this:

Line ID | Booking Ref | Cost
----------------------------
1 | 625467 | 2567
2 | 625467 | 657
3 | 788676 | 7635
4 | 677788 | 764

Because it is a datasheet the user can highlight any number of rows by clicking the row selector to the left of the datasheet (like you do in Excel). I need to know the Line ID of each row that the user has highlighted.

Is this possible? If so how is it done.

Thanks in advance,

~tg

 

[Frink]

Hallo,

I dunno if you can with a subform.
You can if you make it a list box. Use the MultiSelect and Selected properties.

- Frink

 

[RoyVidar]

I've never used it, but here's a link that seems to address the issue Determine selected records in datasheet view.

What I've done in similar situations, is to have a Yes/No field in the underlying recordset of the subform, then a checkbox on the subform and use that as criterion for further processing (then also have some routine to either select or deselect all).

Roy-Vidar

 

[MD5150]

If you don't want to use a multi-select list box, then you can simply add a yes/no checkbox field to the table and subform allowing users to flag specific records. Then just call up all true records or cycle through the recordset finding records where your checkbox = true. But if you do this, you'll probably want to run a clear routine making all check boxes false when the form is opened or closed...or something like that.

Mike