Show selected records on subform-datasheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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".
 
Bertrand said:
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?
Click to expand...

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.
 
Back
Top