Recordset in different colour

[jokobe]

I opening a form for editing from a start form. The start form contains a
one recordset, in the editing form the recordset can be edited, but the
editing form contains all recordsets from a table.
I want to have the selected recordset a different colour (red, or blue),
wehreas the other recordssetz should stay black.

Any helpful hints?

Thanks in advance for any help

jokobe

 

[Dirk Goldgar]

I opening a form for editing from a start form. The start form contains a
one recordset, in the editing form the recordset can be edited, but the
editing form contains all recordsets from a table.
I want to have the selected recordset a different colour (red, or blue),
wehreas the other recordssetz should stay black.

I don't know what you mean by "recordset" in this question; I think you're
using it in an unconventional way. Do you just mean "record"?

Is there a reason you don't open the editing form to display only the record
you want to edit? That would avoid any confusion for the user, and you
wouldn't have to do any special formatting.

 

[jokobe]

Hi Dirk,

o.k. record might be a better expression. There is a reason to show more
than one record: the user can select a new one and with the colour he can
identify the original one.

jokobe

 

[Dirk Goldgar]

I believe you could do this with conditional formatting to set the BackColor
of the various text boxes on the editing form. If the start form will will
be open while the editing form is open, then you should be able to do your
conditional formatting based on an expession similar to

[ID]=[Forms]![StartForm]![ID]

.... where "ID" should be replaced with the name of the primary key field on
each form, and "StartForm" should be replaced with the name of your start
form.

If, on the other hand, the start will not remain open, then you'd probably
have to pass the desired ID value to the editing form, and the editing form
could store that value in a hidden text box, and use a somewhat different
expression to refer to that hidden text box.