sub forms

[alecgreen]

Hi

I have created a sub form on a main form, which produces the required
results, but was wondering

1) can the sub form be changed to a combo box to produce the same
results? (using the underlying query)

2) can you change the background colour of the form footer section in
the sub form from the standard dark grey colour?

and finally

3) one of the fields in the underlying query of my sub form is a yes/no
field, I want the background colour of the selected row to change
depending on the yes/no field

Any help would be appreciated

Thanks

Alec

 

[kingston via AccessMonster.com]

1) Yes, replace the combo box's row source with the query that feeds the
subform.

2) Yes, go into design view for the subform and change the background color
there. Click once on the background and select a different color.

3) Use Format->Conditional Formatting... to change the color of the yes/no
field. If you want to do this for the entire row, you'll need to write some
code to change the the field colors or the record background color. However,
you'll only be able to affect one record at a time unless the form isn't
really a data form and is just displaying static data in a format you
construct on the fly.