Update another field based on Date field.?

[YNWA]

Hi,

I have a field Invoice Date and a field Invoice Month.

On my form how do I get the Month part of the Invoice Date to populate into Invoice Month?

Tried this

Private Sub DateContractSigned_AfterUpdate()
Me.MonthSigned = DateContractSigned(Month)
End Sub

But no joy.

Anyone?

Also anyone know how I can get the letters HH to populate at the start of my invoiceRef field so every invoice will start with HH?

Thanks

 

[pbaldy]

I wouldn't save the month, since it can be derived from the date. You'd want the Month() function for that.

You can concatenate:

"HH" & YourFieldName

 

[YNWA]

I wouldn't save the month, since it can be derived from the date. You'd want the Month() function for that.

You can concatenate:

"HH" & YourFieldName

Cheers.

Were would I put this "HH" &? Control source of Ref field or ? I want to store this.

Same with Month() were do I put this?

 

[YNWA]

Would I need to add a new field to do the concatenate?