Requery fails

[Dega]

I have a form with a button that runs a requery but this fails. There are no errors thrown.
This forces me to close the database form and reopen to see the list box populated correctly.
The problem lies in the subform data, but I have attached a macro to this subform and it still fails.
Anyone have any idea on where to look ?


Thanks

[RuralGuy]

What do you mean by "it fails"? Does it do anything? What is behind the button you mentioned?

[Dega]

When it fails it just doesn't requery.
I thought running a requery macro attached to the button would do it.

frmBookings is the form name.
roomGroupID is the field name which is populated by a query.

Closing and then opening the form displays the new record which was entered using the main form (frmCustomers) ...

Thanks

[RuralGuy]

Requerying a MainForm does not Requery any SubForm on it. You need to specifically requery the SubForm as well.