Add row with just color on user click

[DuMont]

How can I add a full row of color, if let's say I have 5 columns when a user clicked a button?

Docmd.runsql "INSERT INTO tbl ("blank","blank","blank","blank","blank") ... tablerow.backcolor = green ?

Let me know if I need to clarify a bit more. Thanks!

 

[MarkK]

If you only want to insert a value in a single field, only include that field in your insert sql, like . . .

INSERT INTO SomeTable 
( SomeField )
VALUES
( SomeValue )

That'll be fine even if the table has many more fields which will all end up being Null.

 

[CJ_London]

try using conditional formatting. Note this only works for forms and reports and only certain controls