Another continous form format problem?

[geralf]

Hi,

In my continous form (sub form as datasheet) I have a field which when receives focus, jumps to another subform where data can be entered. This works great, but I'd like to get the row in the first SF, to be displayed in another color. This to indicate which record in SF1, data is being entered in SF2. The SF1 acts as a Parent for SF2. SF1 and SF2 has a 1 to many relationship.

Is this possible to do?

I've tried the Conditional Formatting (A2k), but it looses it's color when focus is moved to SF2.

Any thoughts/ideas are most welcome. Thanks!

Gerhard

 

[ChrisO]

Hi Gerhard

This could be a difficult one but maybe we could get it to work.

I only use Access97 so I won't be able to help with the Conditional Formatting but a little A97 style Conditional Formatting may work.

First up have a look at the attached demo, built for another purpose, and click on one of the Red Check Boxes. If you think the result looks promising you would need to remove any Conditional Formatting from your Forms and post an A97 version so I can have a look at it. Only the Form/Sub Forms and a little test data would be needed so you can trash everything else that is not required.

No promises though.

Regards
Chris

 

[geralf]

Hi Chris

Thanks for your reply and attached db. I've looked at it, and it uses a pop-up. I use a sub form (SF1) in continous form view, and when a record in the SF1 is selected, another sub form (SF2)hows the details of the record selected in SF2. SF2 is also a form in continous view, and has a 1 to many relationship with SF1.

I've solved it by adding a hidden check-box control bound to the table, and used the conditional formatting in A2k. I encountered a new problem, with ensuring that the check box was checked/unchecked at the right events. I'm testing this now, and I don't have any more questions regarding this right now.

Pat,
I've looked at your picture, and it looks very good. In my situation with the two sub forms, I considered using a treeview control, but was very unsure if this would work as planned. I have limited time to use on this, and the sample db's I saw seemed to use a lot of VBA, so I droped that approach.

The picture I saw, where you have used sub data sheets (which I haven't used either, but think they would be more easy than treeviews), could this be used as a hierarchic structure? I only need two levels. If possible, how would I make this with the color scheme?

Thank you very much for your reply.


Regards
Gerhard

 

[ChrisO]

Hi Gerhard

Yes, I was just going one step at a time. It uses a Popup to simply demonstrate that the highlighted record remains highlighted when the focus is transferred to something else, be it a Popup or another Sub Form.

However, having said that, I personally wouldn't use the approach I posted if the Conditional Formatting can be made to work the way you want. The A97 method is semi-messy simple because it is fundamentally a work-around that can't really be done in A97 any other way, well not to my knowledge that is.

If Pat, or others, can't help with the in-built Conditional Formatting in A2K then you might have to resort to some form of work-around such as the demo I posted.

Good luck.

Regards
Chris