Requery question

[CSorensen]

I am having trouble getting a requery to execute.

I have two forms. The first is a continuous form showing a list of
transactions with the record source being a query. When the user selects an
Add button, another form is displayed where the user can enter the details
for a new transaction. My problem is that, when the user closes the detail
form, I cannot get the first form to requery the database and show the new
transaction that was entered.

 

[Barron Henderson]

Where are you calling the requery from?

If you open the details form as a dialog (halting next code), you can place
me.requery after the open line and it will execute after the form is closed.
Otherwise place FormName.Requery in the OnClose event of the details form.

Barron

 

[CSorensen]

My problem was that I had not included the argument to open the form as a
dialog. Once I did that, it worked. Thanks!