search for a record on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which contains a record number field [std_op], and also a combo
box [status].

I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record
if it is "LIVE" (one of the choices from the [status].

Hope this makes sense.

Thanks for any help you can offer.
 
Assuming you are using the combo box to perform your search, the best way to
do this is to use a query as the row source for the combo box that includes
only "live" records.
 
I think I may have confused you there.

The find button is looking for the [std_op] number and not the [status]
combo box. Each std-op has one of 4 status.

I only want the user to see the std_op if the [status] is live.

Klatuu said:
Assuming you are using the combo box to perform your search, the best way to
do this is to use a query as the row source for the combo box that includes
only "live" records.

Lynne said:
I have a form which contains a record number field [std_op], and also a combo
box [status].

I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record
if it is "LIVE" (one of the choices from the [status].

Hope this makes sense.

Thanks for any help you can offer.
Click to expand...
Click to expand...
 
No, I understood. How you filter your row source and what the row source
contains are two different things. You need a query that presents [std_op]
for only those rows where [status] is "live".

Lynne said:
I think I may have confused you there.

The find button is looking for the [std_op] number and not the [status]
combo box. Each std-op has one of 4 status.

I only want the user to see the std_op if the [status] is live.

Klatuu said:
Assuming you are using the combo box to perform your search, the best way to
do this is to use a query as the row source for the combo box that includes
only "live" records.

Lynne said:
I have a form which contains a record number field [std_op], and also a combo
box [status].

I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record
if it is "LIVE" (one of the choices from the [status].

Hope this makes sense.

Thanks for any help you can offer.
Click to expand...
Click to expand...
Click to expand...
 
Thanks very much - works a treat now!

Klatuu said:
No, I understood. How you filter your row source and what the row source
contains are two different things. You need a query that presents [std_op]
for only those rows where [status] is "live".

Lynne said:
I think I may have confused you there.

The find button is looking for the [std_op] number and not the [status]
combo box. Each std-op has one of 4 status.

I only want the user to see the std_op if the [status] is live.

Klatuu said:
Assuming you are using the combo box to perform your search, the best way to
do this is to use a query as the row source for the combo box that includes
only "live" records.

:

I have a form which contains a record number field [std_op], and also a combo
box [status].

I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record
if it is "LIVE" (one of the choices from the [status].

Hope this makes sense.

Thanks for any help you can offer.
Click to expand...
Click to expand...
Click to expand...
 
Great, glad I could help.

Lynne said:
Thanks very much - works a treat now!

Klatuu said:
No, I understood. How you filter your row source and what the row source
contains are two different things. You need a query that presents [std_op]
for only those rows where [status] is "live".

Lynne said:
I think I may have confused you there.

The find button is looking for the [std_op] number and not the [status]
combo box. Each std-op has one of 4 status.

I only want the user to see the std_op if the [status] is live.

:

Assuming you are using the combo box to perform your search, the best way to
do this is to use a query as the row source for the combo box that includes
only "live" records.

:

I have a form which contains a record number field [std_op], and also a combo
box [status].

I have a command button for the end users to click to search for a
particular record which works fine, but I would like to only show the record
if it is "LIVE" (one of the choices from the [status].

Hope this makes sense.

Thanks for any help you can offer.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top