Updating Data in a Form

[asmith533]

I have two forms, one for requests and one for inputting in new customers. I have a button on the requests form that opens the customer form to add a new customer. When you close the customer form, the only way to get the new customer to show up is to close the requests form and open it again. Is there a way to make the data update without having to open and close the form? Even better would be to have the field populate with the new customer's name?

[uncletreetrunk]

You should be able to use the Requery command to update your form without having to close and reopen

ie. Forms!FrmName!.Requery or just Me.Requery if you are in the form you want to update

If you set the txtbox's control source, I think a requery would update those as well