Requery Sub-Form

[Simon Argent]

I currently have a form which contains a macro.

When a button is pressed, the macro opens up another form to allow a
user to add data. When the form is closed, I want the macro do do a
Requery so that the new data is instantly available.

What do I need to put into the requery Control Name?

The Sub Form is called 'History_Screen'
The Table is called 'History'
The Field I want updated is called 'Staff/Location'

I have tried History_Screen.History.Staff/Location as the Control
Name, but I am told that this field doesn't exist.

I am new to Access which is why I am probably so stuck!

Thanks :)

[Ed Robichaud]

You need to use the full name of the control in question.

Main form: frmMyForm (or Me)

Subform: frmMyForm!MySub1

Control on subform: frmMyForm!MySub1.form!MyControl

-Ed
"Simon Argent" <Si**********@gmail.comwrote in message
news:2d**********************************@v4g2000h sf.googlegroups.com...

>I currently have a form which contains a macro.

When a button is pressed, the macro opens up another form to allow a
user to add data. When the form is closed, I want the macro do do a
Requery so that the new data is instantly available.

What do I need to put into the requery Control Name?

The Sub Form is called 'History_Screen'
The Table is called 'History'
The Field I want updated is called 'Staff/Location'

I have tried History_Screen.History.Staff/Location as the Control
Name, but I am told that this field doesn't exist.

I am new to Access which is why I am probably so stuck!

Thanks :)