search for a record on a form

[Lynne]

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.

 

[Klatuu]

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]

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.

 

[Klatuu]

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".

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.

 

[Lynne]

Thanks very much - works a treat now!

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".

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.

 

[Klatuu]

Great, glad I could help.

Thanks very much - works a treat now!

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".

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.