shifting focus?

[Poot]

Hiya, I am using:

DoCmd.GoToRecord , Me.Name, acNewRec

to achieve a blank new record upon a user entering my form. They must then choose a company from a combobox before moving to my subform and choosing a date -

after the date has been chosen from another combobox -

the records become "visible = true"!

However, I would then like the user to be able to go up to the parent form again and choose another company with the subform reverting back to only the combobox (date) being visible again.

I have been reading about "onfocus", but understand that it won't? work because there'll still be something on the subform that will be in focus until you return to it! My reasoning being that on lost focus (thinking that it was the entire subform) I could "visible= false" the records again.

Can anyone point me in the right direction?

Thank you for any reply,

Regards,
Poot.

 

[Ally]

I think, if I understand you correctly, that you may need to requery your subform.

On AfterUpdate of the parent form, put:

Me![SubformName].Form.Requery