problems opening a for via VBA

[sdel_nevo]

Hi All



I have a form that has a sub-form on it, this sub-form is not visible when the main form opens, until data is entered into a combo box.

this form opens correctly when opened directly from the nav bar, but when the form is opened by a button (using VBA) on it's on-click event from another form it opens but the sub-form is visible.

if i change the button on-click event to open the form from VBA to a Macro then the form opens correctly (with the sub form not visible)

does anyone know why this is happening, i have never come across anything like this before.

Steve

[RuralGuy]

Any chance you could post your db with at least the three forms involved along with their tables so we can play with them? What code was being used from the button to open the other form?

[sdel_nevo]

Hi Agian RuralGuy

i sure can do, but im not able to do this until tuesday.

the code to open the form is

DoCmd.OpenForm "add bank transfer", acNormal

the form opens but the subform "add quick payment" is visible, although when i open the form via a macro it's not.

i will send you the required details tuesday if thats ok, could i PM you with them then.

Steve

[RuralGuy]

Sure, I'll be around.