ContributionsMost RecentMost LikesSolutionsupdate a field when selecting another fieldin my table "clients" I have a field (DME, Field ID 174) that is a dropdown box. When any change is made in that field I want to automatically update a date field (Sent Date, Field ID 202) to the current date and time. I can't figure out how to do thatchange color of fields on a formI want to highlight the fields that are required on a form by changing the background color of the field to some other color rather than the standard white How?how do I create an append query? I need to create an append query. I have a "leads" table that outside agents populate with a potential sales lead. Once my agent accepts the lead he changes the status of that lead. I need a query, triggered by the status change to append the lead to my "clients" table. Of course I'll also need a delete query to delete the record from the "leads" table. In addition I'll need to be able to create some update queries too for other tasks in my database. I can't find any help on this at all. Gee I miss SQL