expression issue

[bigmac]

hi , don't know if this is the right section for this ,
I have a date textbox [test] and want to change the value of another textbox [update] if the value of [test] is between todays date and last month ,i want to do this using conditional format , can you help please?

 

[isladogs]

Conditional formatting does exactly what it says 'on the tin'
Use an update query or equivalent SQL statement to do this

 

[bigmac]

how would I do this in vba ?

 

[isladogs]

Use syntax similar to

CurrentDb.Execute "UPDATE TableName" & _
" SET TableName.FieldName=some value" & _
" WHERE some condition is true;", dbFailOnError

For more info and examples, see https://www.w3schools.com/sql/sql_update.asp