Filtering Current Record

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

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,

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, 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@All


Steve Schapel said:
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@All said:
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?
Click to expand...
Click to expand...
 
NotGood,

It depends what you mean by "put the info into a e-mail". You can use a
SendObject action in your macro to send an email with data attached, in a
number of possible formats. And if you exported a query, or a report based
on a query, as the basis of what you send, then you could use a reference to
a control (e.g. combobox) on a form in the Criteria of the query, in order
to select the data/record you want. So maybe if you have a look at that
first, and then post back with some more specific details or examples if you
need more help.
 
Back
Top