Continuous Subforms and changing single record 
Author Message
 Continuous Subforms and changing single record

Hi!  I posted this a few weeks ago, but choose a poor time since I was
unable to check newsgroups for the last few weeks..

If you have a continuous subform, is it possible to change the display
properties of just one part of the form, for just that record?

For instance, I have a typical order record, with a parts subform inside of
it with part #, quantity, amount available, etc..  What I would like to do,
is that if the amount requested, is greater then the amount in stock, to
change the color of the Amount Requested edit box.  When I try this, the
color for -all- the Amount Requested boxes (in each of the entries) changes.

Is there an easy way of doing this?  I think this would be of great benifit.

Thanks!,

Fabian
---
(to reply via email, remove NOSPAM from email address)



Fri, 02 Feb 2001 03:00:00 GMT  
 Continuous Subforms and changing single record
Hi!  I posted this a few weeks ago, but choose a poor time since I was
unable to check newsgroups for the last few weeks..

If you have a continuous subform, is it possible to change the display
properties of just one part of the form, for just that record?

For instance, I have a typical order record, with a parts subform inside of
it with part #, quantity, amount available, etc..  What I would like to do,
is that if the amount requested, is greater then the amount in stock, to
change the color of the Amount Requested edit box.  When I try this, the
color for -all- the Amount Requested boxes (in each of the entries) changes.

Is there an easy way of doing this?  I think this would be of great benifit.

Thanks!,

Fabian
---
(to reply via email, remove NOSPAM from email address)



Fri, 02 Feb 2001 03:00:00 GMT  
 Continuous Subforms and changing single record
NicroNet,

No, it is not possible to change the colour the way you (and everyone else)
wants.

The nearest I have managed to this is to have a calculated field, In my case
a function that returns either 1,0 or -1 according to whatever calculation I
want, say 'Min Stock' versus 'In Stock'.

If 'In Stock' > 'Min Stock' return 1; Min=In return 0; In<Min Return -1.

Then I set the 'Format' property for the field to:

"Over"[Blue];"Okay"[Black];"Short"[Red]

This way, I can get a field with the Foreground colour or the words
'Over/Okay/Short' changing at least. Not as effective as being able to
change the background of the field itself, but better than nothing and it
does attract the eye quite well.

Mike

Quote:

>Hi!  I posted this a few weeks ago, but choose a poor time since I was
>unable to check newsgroups for the last few weeks..

>If you have a continuous subform, is it possible to change the display
>properties of just one part of the form, for just that record?

>For instance, I have a typical order record, with a parts subform inside of
>it with part #, quantity, amount available, etc..  What I would like to do,
>is that if the amount requested, is greater then the amount in stock, to
>change the color of the Amount Requested edit box.  When I try this, the
>color for -all- the Amount Requested boxes (in each of the entries)
changes.

>Is there an easy way of doing this?  I think this would be of great
benifit.

>Thanks!,

>Fabian
>---
>(to reply via email, remove NOSPAM from email address)



Sat, 03 Feb 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Click on record in continuous form to go to same record in single form view

2. VB code to change continuous subform to single form

3. Changing from Single Form to Continuous Forms

4. Change subform view from continuous to single in code

5. Open a form in either continuous or single record view

6. Unable to update single record in continuous forms

7. Continuous forms and display options of a single record

8. How to print single record from continuous form?

9. Multiple records on a single form (not continuous)

10. Continuous Subforms Event for Each Record Displayed


 
Powered by phpBB® Forum Software © phpBB Group