Using VBA to Add a String of Text to a Field that already has a string of text

[zashaikh]

Hello. I want to use VBA to add a string of text to a field that already has a string of text (as opposed to replacing it).



For example, lets say I have a field called [Information] in frmMain. This field has a value of "Alpha."

I then use another form (frmTwo) to add a value to the field, such as "Beta". I current use Forms!frmMain.Information.Value - Me.Information.Value. However, this code replaces "Alpha" with "Beta". How to I get it to say "Alpha Beta"

[Bob Fitz]

Maybe:

Forms!frmMain.Information & " " & Me.Information

[Bulzie]

Forms!frmMain.Information = Forms!frmMain.Information & " - " & Me.Information

If you are adding data you need to start with the main field each time, then add the new data. You may want to add a Save command after also as it might not save the record on the Main screen.

[zashaikh]

Ah thank you. I tried Forms!frmMain.Information AND " - " & Me.Information. For some reason, I keep forgetting to use &.