Search form and few of the problems running it!

[Modesty_Blaze]

Ok, I'm working on one project for children hospital where they are have records on children that have hip problems at birth.
I have table 'Patient' and fields on which i need search are:
‘Name’ (text) ‘code’ (Number -indexed no dup.) 'Alpha angle R' 'Alpha angle L' 'Beta angle R' 'Beta angle L'. These hip angles are drawn from table Angles (range from 35 to 95).
Search form has six cmd buttons (for each search). on Click they start different Macros (Close Search; Openform Search by 'choice') which run forms with record sources in appropriate Queries ( This is what I put in Criteria:[Forms]![Search].['CmdName'] Or Is Null ). Problem is that I get results only from 'Name' and 'Code' buttons, but no results from angle buttons.
(When I click on any cmd button little box appears asking for value
" Enter parameter value
Forms!search.AlphaangleL")...

I have searched all of the forums and didn't find anything similar to this problem...
Would greatly appreciate any ideas! Thanks,

Sometimes I can't see the forest because of the trees

 

[Mile-O]

Have you really used apostrophes in table and field names? Bad practice.

Your field Name is also bad as this is a reserved word in Access.

Are your numbers being converted properly? i.e. Are you trying to query some fields where you think they are numeric but are actually text ("2" and 2 are not the same)

 

[Modesty_Blaze]

Three things

First, Mile thanks for the input, I did corrected the Name thing, and didn’t use the apostrophes.

Second,
I made it!!!
In search form I put (instead of textbox or cmd button) combo box that has a row source in table Angle receiving values from 35-95. In After Update on combo box I put macro that runs proper form whose row source is in query where criteria is [Forms]![search].[angle].
OK, I'm done with bragging!

But...

Third thing (Mile -O- Pile made me think about it - THANKS, I love when someone shows me where the real challenge is!!!)
Now I'll try to make it with the text box (Numbers and text thing)
and then to see if I can make it to just give a range of angles to search (for example: one textbox 44 second 63 and result to have all records in that range)!
when I'm done I'll post it here.

 

[Modesty_Blaze]

New issue being raised

Now I still haven't made the changes that I spoke above, but there is a another issue being raised:

Since this DB is for keeping records for children with hip problems, Dr. that is in charge for this project asked me about making another DB for records of hip Ultrasound photographs. I'm thinking, since these photos aren't that large can they be inserted into the DB (and HOW) once they are scaned?
It would be on another form that would be open from the patient form with cmd Button.

Any info on this?
Can't find any threds that cover this one...