auto populate text field with info help needed

[crombiecrunch]

Hello All



I have a text field that I would like to have some information automatically populated when the form is open. I know the basics but the trouble I am having is having the date and time populated before the default text.

here is what I tried but no luck on it

Private Sub Form_Load()
Dim strQuery As String
'Dim js As Integer
Dim currDateTime As Date
currDateTime = Now()
Me.Description = " & currDateTime & " & " " & "J.Adams 41066 CLT SMB - AM : " & " " & ""
End Sub

[NTC]

Me.Description = currDateTime & "J.Adams 41066 CLT SMB - AM : "

[June7]

Is this a bound form? If so, then should move to new record row first, otherwise will change data of existing record. Or is this form DataEntry property set to Yes?

Too many quote marks and concatenation.

= currDateTime & " J.Adams 41066 CLT SMB - AM : "

Why do you want to save this calculated value? It can be generated when needed - no need to save.

Not sure what you mean be "before the default text".

What does 'no luck' mean - what happens?

[RuralGuy]

What happens when you use the following?
Me.Description = "J.Adams 41066 CLT SMB - AM : "

[crombiecrunch]

Me.Description = currDateTime & "J.Adams 41066 CLT SMB - AM : "

Ugh, I swear I thought I tried this one. Thank you its working as needed now.