I am creating a form which will be used to track payments to organizations. The "payee name" is sometimes different than the "organization name." How do I create a "Payee Name" field that will default to the "Organization Name," with the ability to type over the default? Mind you I do not know SQL, so if it is do-able without this knowledge, I would appreciate some help!

This works for data entry purposes.

On the AfterUpdate event of the [OrganizationName], put this code..


Me.PayeeName = Me.OrganzationName

No love. Did I need to do something to the PayeeName field for the code jwindon's solution to work?

Take a look at the Order form in northwind.mdb or orders.mdb. When you select a customer, the bill to and ship to addresses are populated from the customer information. The ship to info may be overwritten and is stored with the order.

Your process is logically identical.