bringing info from one field to another

[Dave Eliot]

I have a table with fields [Title] and [Alpha]. After I enter the title, I
would like that title to automatically be entered into the Alpha field, and
be editable.

 

[Allen Browne]

In your form, use the AfterUpdate event procedure of Title to assign the
value to Alpha.

The code would look like this:
Private Sub Title_AfterUpdate
Me.Alpha = Me.Title
End Sub

 

[Dave Eliot]

You have made my day!
Thank you.

In your form, use the AfterUpdate event procedure of Title to assign the
value to Alpha.

The code would look like this:
Private Sub Title_AfterUpdate
Me.Alpha = Me.Title
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a table with fields [Title] and [Alpha]. After I enter the title, I
would like that title to automatically be entered into the Alpha field,
and be editable.