Need to make form field default to the value of the preceding field.

[BruceWaller]

How do I make my "ship to" address default to the value filled in on the previous field "bill to" address on my Access 2010 form. Thanks for your help. I've been googling for 20 minutes and striking out. Promised this database would be done tomorrow morning so I need to add as many user-friendly shortcuts, bells, and whistles as possible because I still have a ton of work to do on queries and reports. Thanks for your help.

 

[SydneyGeek]

Assuming the field names are BillTo and ShipTo, put this code in the AfterUpdate event of BillTo:

Me.ShipTo = Me.BillTo

If you haven't built event code before, do this:
Double-click the blank row next to the After Update event (Properties, Event tab)
You should see [Event Procedure]. Now click on the ... button at the end of the line and you will be taken to the code window.
The blank line before End Sub is where the code goes.

Note: This is the method if both controls are text boxes. If one or morw of them is a combo box, you will need a slightly different approach. Let me know if that is the case, and what types of controls you are using.

Denis

 

[BruceWaller]

Sydney... that worked like a charm. Thank you very much for taking the time to help me out. Bruce