A have a subform in datasheet format, when I check the box 'mark', the whole line should be colored red..

http://www.robert-weirauch.com/subform.gif
(this is how it should look, photoshop is easyer ;-))

I also would like to autonumber the ritnr. field.. (each new subform from 1 up)

How do I do this? note that I'm only a beginner!!

Thanks,

Wouter.

[This message has been edited by wouter (edited 02-05-2002).]

To show a field in your subform starting at 1 every time, try this thread by Alexandre: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002923.html
And Jack Cowley has done some good research on the Microsoft Support database here: http://www.access-programmers.co.uk/ubb/Forum4/HTML/004835.html

Found with: Search: number sub from 1

As for your other question, how familiar are you with MS Access Conditional Formatting? You can use this in some cases, otherwise I would suggest using the Current event of the subform to change the color of the backgrounds of your fields (don't make it so strenuously different that you can't read it).
I found several topics dealing with this, one may speak to you. Do a Search in all Forums: condit format line (leave off the word line and you'll get more results).

HTH,
David R

I'm not trying to be unhelpful, but the search engine here on Access-Programmers is really powerful and flexible. If you enter part of a word it will search for any word containing that text, hence the 'condit' above. You can also find answers at a variety of skill levels, which can be helpful when you're just starting out.

Please post back to this topic if you start running into more specific brick walls. Someone will be glad to offer help, and it might even be correct. http://www.access-programmers.co.uk/ubb/biggrin.gif

[This message has been edited by David R (edited 02-05-2002).]