Subforms

  • Thread starter Thread starter Paul Wheeler
  • Start date Start date
P

Paul Wheeler

Hi,

I have a form with a combo box on it. the value that i
select in the combo box is transfered to a query. the
results of that query are displayed in a subform on the
main form...

i.e if i select London in the combo box i get all records
in the subform that meet the criteria London.

what i want to be able to do is select one of the records
on in the subform and change its colour to red. then
click on another record and change that to red and so
on ....
 
If you add a boolean field represented by a checkbox for selected rows, you
could use conditional formatting (Access 2000-2002) to turn the "selected"
rows red. This feature allows you to specify upto 3 conditions and
formatting options for when the each of the conditions is met. Just set a
condition based on the boolean field.

To use, select the control, click Format, Conditional Formatting. Check the
help for more details.
 
Sandara thank you for your response, but im using access
97. does you advice still apply?
-----Original Message-----
If you add a boolean field represented by a checkbox for selected rows, you
could use conditional formatting (Access 2000-2002) to turn the "selected"
rows red. This feature allows you to specify upto 3 conditions and
formatting options for when the each of the conditions is met. Just set a
condition based on the boolean field.

To use, select the control, click Format, Conditional Formatting. Check the
help for more details.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Paul said:
Hi,

I have a form with a combo box on it. the value that i
select in the combo box is transfered to a query. the
results of that query are displayed in a subform on the
main form...

i.e if i select London in the combo box i get all records
in the subform that meet the criteria London.

what i want to be able to do is select one of the records
on in the subform and change its colour to red. then
click on another record and change that to red and so
on ....
Click to expand...


.
Click to expand...
 
Yes and no - conditional formatting isn't a feature in Access97 but thanks
to Stephen Lebans, there is another solution. Take a look at his
FormatByCriteria samples:
http://www.lebans.com/formatbycriteria.htm

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Paul said:
Sandara thank you for your response, but im using access
97. does you advice still apply?
-----Original Message-----
If you add a boolean field represented by a checkbox for selected
rows, you could use conditional formatting (Access 2000-2002) to
turn the "selected" rows red. This feature allows you to specify
upto 3 conditions and formatting options for when the each of the
conditions is met. Just set a condition based on the boolean field.

To use, select the control, click Format, Conditional Formatting.
Check the help for more details.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Paul said:
Hi,

I have a form with a combo box on it. the value that i
select in the combo box is transfered to a query. the
results of that query are displayed in a subform on the
main form...

i.e if i select London in the combo box i get all records
in the subform that meet the criteria London.

what i want to be able to do is select one of the records
on in the subform and change its colour to red. then
click on another record and change that to red and so
on ....
Click to expand...


.
Click to expand...
Click to expand...
 
Sandra,

thank you for your response but im working on 97 (should
have told you that before)...will this still work..

Paul
-----Original Message-----
If you add a boolean field represented by a checkbox for selected rows, you
could use conditional formatting (Access 2000-2002) to turn the "selected"
rows red. This feature allows you to specify upto 3 conditions and
formatting options for when the each of the conditions is met. Just set a
condition based on the boolean field.

To use, select the control, click Format, Conditional Formatting. Check the
help for more details.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Paul said:
Hi,

I have a form with a combo box on it. the value that i
select in the combo box is transfered to a query. the
results of that query are displayed in a subform on the
main form...

i.e if i select London in the combo box i get all records
in the subform that meet the criteria London.

what i want to be able to do is select one of the records
on in the subform and change its colour to red. then
click on another record and change that to red and so
on ....
Click to expand...


.
Click to expand...
 
Back
Top