Requery Sub-Form

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 :)

Re: Requery Sub-Form

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" wrote in message
news:2d91c332-e5ea-4c8c-90f4-4e8e7df45a4e@v4g2000hsf.googleg roups.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 :)