Auto Populate Field(s) on Form

[JamesJKusch]

Afternoon Folk,

Here is the dirt:

Have linked tables from Access2K to Oracle8i. built a data entry form to populate tables. i need to have a value that is entered in a text box to populate the associated field in the table as well as another feild in the same table. In otherwords to have 1 entered value update 2 or more columns in the table, or tables if needed and display it on the form in both places i have defined. Example

Form has 3 Entries: FirstName, LastName, NickName

i want to be able to enter "John" in the FirstName and have it auto populate the Form and field NickName w/ "John" as soon as the user moves to the next field. If the user wants to change the NickName to something else, great, they can. If they choose to save/update the record as is, i want the value "John" to be updated in the FirstName and NickName fields and display in both text boxes of the form.

Any help is always greatly appriciated!

Thanks

J. Kusch


J. Kusch

 

[THoey]

Did you try adding a line of code to the lost focus event of the text box thta would assign the first name to the nick name field? Something like:

Private Sub txtFName_LostFocus()
Me!txtNickName = Me!txtFirstName
End Sub

Hope that helps...
Terry M. Hoey