> 1. in the data environment i have built a connection, and a command
object.
> the command object is using a SQL Statement to create a recordset.  my
> question is how can i pass a variable into this SQL Select like i would in
a
> recordsource.  such as:

> "SELECT * FROM Table WHERE Field = '" & Variable & "'"

> i want to do this because i often want to search something like a customer
> table for a specific Last Name the user enters.  i hope this is possible
to
> do.

> 2.  in a data report how can i print only the selected record in a
> recordset.  such as if i have an employee recordset and i want to print
info
> for just one of say 10 employees, how would that be acomplished?

> if anyone can help me that would be great.  thanks.

> Guy

>Leave your setup of the data environment and data report as you have it,
but
>for 1, change the underlying SQL of the command object in code.  For 2, use
>a  second instance of the recordset in question to display the recordset on
>a form so that the user can select the record wanted, then use code to
>change the underlying SQL of the command object so that the only record in
>the command object is the selected record.

>> i have 2 questions to ask.  one about the Data Environment, and one about
>> the Data Report.

>> 1. in the data environment i have built a connection, and a command
>object.
>> the command object is using a SQL Statement to create a recordset.  my
>> question is how can i pass a variable into this SQL Select like i would
in
>a
>> recordsource.  such as:

>> "SELECT * FROM Table WHERE Field = '" & Variable & "'"

>> i want to do this because i often want to search something like a
customer
>> table for a specific Last Name the user enters.  i hope this is possible
>to
>> do.

>> 2.  in a data report how can i print only the selected record in a
>> recordset.  such as if i have an employee recordset and i want to print
>info
>> for just one of say 10 employees, how would that be acomplished?

>> if anyone can help me that would be great.  thanks.

>> Guy

> >> i have 2 questions to ask.  one about the Data Environment, and one about
> >> the Data Report.

> >> 1. in the data environment i have built a connection, and a command
> >object.
> >> the command object is using a SQL Statement to create a recordset.  my
> >> question is how can i pass a variable into this SQL Select like i would
> in
> >a
> >> recordsource.  such as:

> >> "SELECT * FROM Table WHERE Field = '" & Variable & "'"

> >> i want to do this because i often want to search something like a
> customer
> >> table for a specific Last Name the user enters.  i hope this is possible
> >to
> >> do.

> >> 2.  in a data report how can i print only the selected record in a
> >> recordset.  such as if i have an employee recordset and i want to print
> >info
> >> for just one of say 10 employees, how would that be acomplished?

> >> if anyone can help me that would be great.  thanks.

> >> Guy

>In code to open report:
>DataEnv1.Command1 txtField.text    'where txtField.txt is holding the
search
>variable
>ie. employee number.
>DataReport1.Show

>It works for me.
>-Fitz

>> >> i have 2 questions to ask.  one about the Data Environment, and one
about
>> >> the Data Report.

>> >> 1. in the data environment i have built a connection, and a command
>> >object.
>> >> the command object is using a SQL Statement to create a recordset.  my
>> >> question is how can i pass a variable into this SQL Select like i
would
>> in
>> >a
>> >> recordsource.  such as:

>> >> "SELECT * FROM Table WHERE Field = '" & Variable & "'"

>> >> i want to do this because i often want to search something like a
>> customer
>> >> table for a specific Last Name the user enters.  i hope this is
possible
>> >to
>> >> do.

>> >> 2.  in a data report how can i print only the selected record in a
>> >> recordset.  such as if i have an employee recordset and i want to
print
>> >info
>> >> for just one of say 10 employees, how would that be acomplished?

>> >> if anyone can help me that would be great.  thanks.

>> >> Guy