auto form update

[burger54]

I have a form, lets call it form A, that displays a list of projects that need completed. The record source for form A is a simple select Query. when you click on a record it shows a detailed description of the task in a new form, lets call it form B. Form A stays open in the background while form b is open. There is a button on form B which marks the task as completed, which is a yes/no box in the source table. this button also closes form B. My problem is the list of projects does not automatically update form A when form B is closed. Is there a way to make it auto update. everytime i try DoCmd. requery I either get no result or an error message. Any guidance?

[TerryDM]

I have a form, lets call it form A, that displays a list of projects that need completed. The record source for form A is a simple select Query. when you click on a record it shows a detailed description of the task in a new form, lets call it form B. Form A stays open in the background while form b is open. There is a button on form B which marks the task as completed, which is a yes/no box in the source table. this button also closes form B. My problem is the list of projects does not automatically update form A when form B is closed. Is there a way to make it auto update. everytime i try DoCmd. requery I either get no result or an error message. Any guidance?

The record on form A retains the focus while you are in form B. So in your button click event just set the value directly:

forms![formA]![status] = me![status]

[burger54]

Forms![OpenTest2]![Status] = Me![Status]
DoCmd.close

that it what I put inside form 2 right before close. OpenTest2 is the name of Form A. Access gives me the error:
"Access can't find the field 'Status' referred to in your expression." It is referring to the "=me![Status]".
what did i do wrong?

[NeoPa]

In FormB put :

Private Sub Form_Close()
  '... Any existing code
  Call Forms![FormA].Requery
End Sub