From: sebastico on
Jeannete

Thank you very much.
This code is what I been looking
"Jeanette Cunningham" wrote:

> Jeff,
> On the close button of form1st put this code
>
> DoCmd.OpenForm "form2nd",,,,,,"value of variable"
> DoCmd.Close acForm, Me.Name
>
> Jeanette Cunningham
>
>
> "Jeff @ CI" <JeffCI(a)discussions.microsoft.com> wrote in message
> news:A772D397-CA76-4D66-B60B-B739C0D1F435(a)microsoft.com...
> >I would like to be able to open a form by clicking a button, once that form
> > is open and a variable is transferred, I would like to close the original
> > form. I have tried to embed a DoCmd.Close acForm "formname", into a
> > "OnClick" event procedure, but I still have the first form open. Need it
> > in
> > 2000 format.
> >
> > Thanks for any help!
>
>
>
 | 
Pages: 1
Prev: How To: Ribbons
Next: Move Files after import