Combo Box selecting only one record

J

Jp3007

I have a massive test file data base with a lot of information. I want other
to use it and make it user friendly. I Created a form with a combo box to
help them search for a particular test and all the information about that
test. It works great, you can select the test from the combo box and the
data fall in to the form just fine. But, if the person uses the thumb wheel
the data in the form changes to the next record. This could be a potential
problem as they mey use the wrong information for testing. Is there a way to
prevent this? Show only the test data they selected?
 
J

Jp3007

I believe so. I added the combo box to the form. I created a query to
create alphabetical listing. It pulls the information from that query.
 
K

KARL DEWEY

Post the SQL for the query. In query design view click on menu VIEW - SQL
View. Copy and paste in reply.
 
J

Jp3007

SELECT [TEST FILE].[Label Nomenclature], [TEST FILE].ID, [TEST FILE].[Test
Name], [TEST FILE].[Single Test/Part of a panel, not orderable], [TEST
FILE].[Test #], [TEST FILE].Labs, [TEST FILE].Method, [TEST FILE].[Specimen
1st], [TEST FILE].[Sample 1st], [TEST FILE].[Specimen 2nd], [TEST
FILE].[Sample 2nd], [TEST FILE].[Specimen 3rd], [TEST FILE].[Sample 3rd],
[TEST FILE].[Minimum sample], [TEST FILE].[Minimum sample 2nd], [TEST
FILE].[Minimum sample 3rd], [TEST FILE].[Collection Requirement], [TEST
FILE].Processing, [TEST FILE].[Storage 1st], [TEST FILE].[Storage 2nd], [TEST
FILE].[Storage 3rd], [TEST FILE].Cost, [TEST FILE].Panel, [TEST FILE].[Single
test in panel>>], [TEST FILE].Synonym1, [TEST FILE].Synonym2, [TEST
FILE].Synonym3, [TEST FILE].Synonym4, [TEST FILE].Synonym5, [TEST
FILE].Section, [TEST FILE].Stability, [TEST FILE].[Normal Range1], [TEST
FILE].Units1, [TEST FILE].[Normal Range2], [TEST FILE].Units2, [TEST
FILE].[Normal Range3], [TEST FILE].Units3, [TEST FILE].[Normal Range4], [TEST
FILE].Units4, [TEST FILE].[Male Normal Range], [TEST FILE].Units5, [TEST
FILE].[Female Normal Range], [TEST FILE].Units6, [TEST FILE].Linearity, [TEST
FILE].Diluent, [TEST FILE].[Dilution factor], [TEST FILE].Held, [TEST
FILE].[Turn Around], [TEST FILE].Available, [TEST FILE].[VISTA TEST #], [TEST
FILE].[Purple/EDTA 4ml], [TEST FILE].[Red/Plain 9ml], [TEST FILE].[Red/Gel
5ml], [TEST FILE].[Red/Gel 8ml], [TEST FILE].[White/K2 EDTA 5ml], [TEST
FILE].[Green/Sodium Hep 10ml], [TEST FILE].[Green/Sodium Hep 6ml], [TEST
FILE].[Green/Lithium Hep 5ml], [TEST FILE].[Green/Lithium Hep 3ml], [TEST
FILE].[Blue/Sodium Citrate 3 1/2ml], [TEST FILE].[Gray/Fluoride-Oxalate],
[TEST FILE].[Yellow/ACD-B], [TEST FILE].[Tan/EDTA], [TEST FILE].[Royal
Blue/EDTAorHep], [TEST FILE].[Royal Blue/Serum], [TEST FILE].[Rm Temp], [TEST
FILE].Refrigerated, [TEST FILE].Frozen, [TEST FILE].[CPT Code 1], [TEST
FILE].[CPT Code 2], [TEST FILE].[CPT Code 3], [TEST FILE].[CPT Code 4], [TEST
FILE].[CPT Code 5], [TEST FILE].[CPT Code 6], [TEST FILE].[Clinical
Significance:], [TEST FILE].[Clinica Sinificance cont:], [TEST FILE].Mon,
[TEST FILE].Tue, [TEST FILE].Wed, [TEST FILE].Thu, [TEST FILE].Fri, [TEST
FILE].Sat, [TEST FILE].Sun, [TEST FILE].Batched, [TEST FILE].[Single
Test/Part of a panel, not orderable]
FROM [TEST FILE]
WHERE ((([TEST FILE].[Single Test/Part of a panel, not orderable])=No))
ORDER BY [TEST FILE].[Label Nomenclature];

This is from the queries menu, is this what you requested?
 
K

KARL DEWEY

Try changing the WHERE statement to Yes like --

WHERE ((([TEST FILE].[Single Test/Part of a panel, not orderable])=Yes))


Jp3007 said:
SELECT [TEST FILE].[Label Nomenclature], [TEST FILE].ID, [TEST FILE].[Test
Name], [TEST FILE].[Single Test/Part of a panel, not orderable], [TEST
FILE].[Test #], [TEST FILE].Labs, [TEST FILE].Method, [TEST FILE].[Specimen
1st], [TEST FILE].[Sample 1st], [TEST FILE].[Specimen 2nd], [TEST
FILE].[Sample 2nd], [TEST FILE].[Specimen 3rd], [TEST FILE].[Sample 3rd],
[TEST FILE].[Minimum sample], [TEST FILE].[Minimum sample 2nd], [TEST
FILE].[Minimum sample 3rd], [TEST FILE].[Collection Requirement], [TEST
FILE].Processing, [TEST FILE].[Storage 1st], [TEST FILE].[Storage 2nd], [TEST
FILE].[Storage 3rd], [TEST FILE].Cost, [TEST FILE].Panel, [TEST FILE].[Single
test in panel>>], [TEST FILE].Synonym1, [TEST FILE].Synonym2, [TEST
FILE].Synonym3, [TEST FILE].Synonym4, [TEST FILE].Synonym5, [TEST
FILE].Section, [TEST FILE].Stability, [TEST FILE].[Normal Range1], [TEST
FILE].Units1, [TEST FILE].[Normal Range2], [TEST FILE].Units2, [TEST
FILE].[Normal Range3], [TEST FILE].Units3, [TEST FILE].[Normal Range4], [TEST
FILE].Units4, [TEST FILE].[Male Normal Range], [TEST FILE].Units5, [TEST
FILE].[Female Normal Range], [TEST FILE].Units6, [TEST FILE].Linearity, [TEST
FILE].Diluent, [TEST FILE].[Dilution factor], [TEST FILE].Held, [TEST
FILE].[Turn Around], [TEST FILE].Available, [TEST FILE].[VISTA TEST #], [TEST
FILE].[Purple/EDTA 4ml], [TEST FILE].[Red/Plain 9ml], [TEST FILE].[Red/Gel
5ml], [TEST FILE].[Red/Gel 8ml], [TEST FILE].[White/K2 EDTA 5ml], [TEST
FILE].[Green/Sodium Hep 10ml], [TEST FILE].[Green/Sodium Hep 6ml], [TEST
FILE].[Green/Lithium Hep 5ml], [TEST FILE].[Green/Lithium Hep 3ml], [TEST
FILE].[Blue/Sodium Citrate 3 1/2ml], [TEST FILE].[Gray/Fluoride-Oxalate],
[TEST FILE].[Yellow/ACD-B], [TEST FILE].[Tan/EDTA], [TEST FILE].[Royal
Blue/EDTAorHep], [TEST FILE].[Royal Blue/Serum], [TEST FILE].[Rm Temp], [TEST
FILE].Refrigerated, [TEST FILE].Frozen, [TEST FILE].[CPT Code 1], [TEST
FILE].[CPT Code 2], [TEST FILE].[CPT Code 3], [TEST FILE].[CPT Code 4], [TEST
FILE].[CPT Code 5], [TEST FILE].[CPT Code 6], [TEST FILE].[Clinical
Significance:], [TEST FILE].[Clinica Sinificance cont:], [TEST FILE].Mon,
[TEST FILE].Tue, [TEST FILE].Wed, [TEST FILE].Thu, [TEST FILE].Fri, [TEST
FILE].Sat, [TEST FILE].Sun, [TEST FILE].Batched, [TEST FILE].[Single
Test/Part of a panel, not orderable]
FROM [TEST FILE]
WHERE ((([TEST FILE].[Single Test/Part of a panel, not orderable])=No))
ORDER BY [TEST FILE].[Label Nomenclature];

This is from the queries menu, is this what you requested?
--
JPK


KARL DEWEY said:
Post the SQL for the query. In query design view click on menu VIEW - SQL
View. Copy and paste in reply.
Click to expand...
Click to expand...
 
J

Jp3007

If I Change that to "YES", I will get only the single test. Our test file is
set up with panels and tests. Those records that have the single test check
as yes are part of a panel and not orderable tests by them selves. So I put
in the query, if the "Single test is checked (Yes), I don't want the nurses
to see that test (they won't be able to order that test anyway. Less
confusion for them. Does this make sense. The combo box allow the
informatio to filter into the form just fine. Example, if the combo box you
put Glucose and hit enter, all the information for glucose is entered into
the form (Test name, what specimen to draw, when testing is done etc.) If
they try to cusor down using a thumb wheel on the mouse the data changes to
the next record. The combo box stays the same. I'm trying to keep The record
in the combobox and in the form the same. i hope i'm making sense. I do
apprciate your help. I've been fiddling with this for hours with no luck.
Jim
--
JPK


KARL DEWEY said:
Try changing the WHERE statement to Yes like --

WHERE ((([TEST FILE].[Single Test/Part of a panel, not orderable])=Yes))


Jp3007 said:
SELECT [TEST FILE].[Label Nomenclature], [TEST FILE].ID, [TEST FILE].[Test
Name], [TEST FILE].[Single Test/Part of a panel, not orderable], [TEST
FILE].[Test #], [TEST FILE].Labs, [TEST FILE].Method, [TEST FILE].[Specimen
1st], [TEST FILE].[Sample 1st], [TEST FILE].[Specimen 2nd], [TEST
FILE].[Sample 2nd], [TEST FILE].[Specimen 3rd], [TEST FILE].[Sample 3rd],
[TEST FILE].[Minimum sample], [TEST FILE].[Minimum sample 2nd], [TEST
FILE].[Minimum sample 3rd], [TEST FILE].[Collection Requirement], [TEST
FILE].Processing, [TEST FILE].[Storage 1st], [TEST FILE].[Storage 2nd], [TEST
FILE].[Storage 3rd], [TEST FILE].Cost, [TEST FILE].Panel, [TEST FILE].[Single
test in panel>>], [TEST FILE].Synonym1, [TEST FILE].Synonym2, [TEST
FILE].Synonym3, [TEST FILE].Synonym4, [TEST FILE].Synonym5, [TEST
FILE].Section, [TEST FILE].Stability, [TEST FILE].[Normal Range1], [TEST
FILE].Units1, [TEST FILE].[Normal Range2], [TEST FILE].Units2, [TEST
FILE].[Normal Range3], [TEST FILE].Units3, [TEST FILE].[Normal Range4], [TEST
FILE].Units4, [TEST FILE].[Male Normal Range], [TEST FILE].Units5, [TEST
FILE].[Female Normal Range], [TEST FILE].Units6, [TEST FILE].Linearity, [TEST
FILE].Diluent, [TEST FILE].[Dilution factor], [TEST FILE].Held, [TEST
FILE].[Turn Around], [TEST FILE].Available, [TEST FILE].[VISTA TEST #], [TEST
FILE].[Purple/EDTA 4ml], [TEST FILE].[Red/Plain 9ml], [TEST FILE].[Red/Gel
5ml], [TEST FILE].[Red/Gel 8ml], [TEST FILE].[White/K2 EDTA 5ml], [TEST
FILE].[Green/Sodium Hep 10ml], [TEST FILE].[Green/Sodium Hep 6ml], [TEST
FILE].[Green/Lithium Hep 5ml], [TEST FILE].[Green/Lithium Hep 3ml], [TEST
FILE].[Blue/Sodium Citrate 3 1/2ml], [TEST FILE].[Gray/Fluoride-Oxalate],
[TEST FILE].[Yellow/ACD-B], [TEST FILE].[Tan/EDTA], [TEST FILE].[Royal
Blue/EDTAorHep], [TEST FILE].[Royal Blue/Serum], [TEST FILE].[Rm Temp], [TEST
FILE].Refrigerated, [TEST FILE].Frozen, [TEST FILE].[CPT Code 1], [TEST
FILE].[CPT Code 2], [TEST FILE].[CPT Code 3], [TEST FILE].[CPT Code 4], [TEST
FILE].[CPT Code 5], [TEST FILE].[CPT Code 6], [TEST FILE].[Clinical
Significance:], [TEST FILE].[Clinica Sinificance cont:], [TEST FILE].Mon,
[TEST FILE].Tue, [TEST FILE].Wed, [TEST FILE].Thu, [TEST FILE].Fri, [TEST
FILE].Sat, [TEST FILE].Sun, [TEST FILE].Batched, [TEST FILE].[Single
Test/Part of a panel, not orderable]
FROM [TEST FILE]
WHERE ((([TEST FILE].[Single Test/Part of a panel, not orderable])=No))
ORDER BY [TEST FILE].[Label Nomenclature];

This is from the queries menu, is this what you requested?
--
JPK


KARL DEWEY said:
Post the SQL for the query. In query design view click on menu VIEW - SQL
View. Copy and paste in reply.

:

I believe so. I added the combo box to the form. I created a query to
create alphabetical listing. It pulls the information from that query.
--
JPK


:

Are you using the ComboBox as criteria for query as record source for the
form?

:

I have a massive test file data base with a lot of information. I want other
to use it and make it user friendly. I Created a form with a combo box to
help them search for a particular test and all the information about that
test. It works great, you can select the test from the combo box and the
data fall in to the form just fine. But, if the person uses the thumb wheel
the data in the form changes to the next record. This could be a potential
problem as they mey use the wrong information for testing. Is there a way to
prevent this? Show only the test data they selected?
Click to expand...
Click to expand...
Click to expand...
 
Top