Steve, Hi. Thank You very much. That was perfect. The more I learn, the
more questions I have. I want to create something (I'm not sure how to go
about this but I want to use a dropdown to select the data, have the form or
query populate, then have another button that will put the selected info into
a e-mail for me. I don't exactly know how to start. Would you point me in
the right direction? Do I create a query or a form? If you would give me
the steps I should follow, I could play. I just don't want to do things
backwards as usual
Thank You
--
NotGood[ at ]All
"Steve Schapel" wrote:
[Quoted Text] > NotGood,
>
> I assume you mean that the continuous form only shows certain core data, and
> you want to open up another form, with the full details of the continuous
> form's current record. Does that sound right? So the button is in the
> Detail section of the continuous form? You will want the button to have a
> macro assigned to its Click event, and the macro will use an OpenForm
> action, nominating the name of the full detail form. And the Where
> Condition argument of the OpenForm action will need to reference the
> field(s) that identify the record you want, which will most likely be the
> Primary Key field from the forms' underlying table. A typical Where
> Condition argument looks something like this:
> [YourID]=[Forms]![NameOfContinuousForm]![YourID]
>
> Hope that helps clarify.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> "NotGood[ at ]All" <NotGoodAll[ at ]discussions.microsoft.com> wrote in message
> news:7023C40B-EA51-46C1-BDC3-7204BBDDD3B6[ at ]microsoft.com...
> > I have a continuous form with a button on it. What I’m trying to do is
> > when
> > the button is clicked open the record of the button that was clicked. I’ve
> > been playing, but the more I play the worse it gets. Would someone point
> > me
> > in the right direction?
> > --
> > NotGood[ at ]All
>
|