Show selected records on subform-datasheets

[Bertrand]

Hi,

I use a subform displaying a datasheet (Access 2002). When the subform
looses the focus the selected rows are no longer highlighted and the
selection is lost. Is there a simple way to make the subform/datasheet keep
the selection when loosing focus?

Best regards
Bertrand

 

[Steve Schapel]

Bertrand,

No, not really. Generally it would probably be preferable to select
records based on data rather than highlighting them in a datasheet
anyway. Maybe if you could explain a little of what you are trying to
achieve, someone may be able to advise further.

 

[Bertrand]

Hi Steve,

I need to establish a link between two sets of records. So I want the user
to be able to select records in two datasheets and then press a button to
create the link. There is ofcause workarounds but i was trying to achieve
what i think is the normal "usage modal" i.e. the records are highligheted
when they are selected.'

Bertrand

 

[Steve Schapel]

Bertand,

I am sorry, I do not understand what you mean about "establish a link
between two sets of records". Maybe if you could give an example it may
help illustrate what you are trying to do. In any case, I can certainly
assure you that selecting records for data manipulation by highlighting
them is not "normal usage model".

 

[Dirk Goldgar]

Hi,

I use a subform displaying a datasheet (Access 2002). When the subform
looses the focus the selected rows are no longer highlighted and the
selection is lost. Is there a simple way to make the
subform/datasheet keep the selection when loosing focus?

No. You can, however, capture the keys of the selected records before
the subform loses focus. If you want the selections in both subform to
be visible as highlighted rows, though, I think you'd have to use list
boxes instead of subforms.