Link to home
Create AccountLog in
Avatar of PDSWSS
PDSWSS

asked on

Why do I get an Enter Parameter Value Window in MS Access 2007?

I have attached a part of the MS Access 2007 DB that is relevant to my question.

Please open the form =  copyfrmmedication_lst
Next click on the Enter button on the far right of the row that contains Ritalin.

Would like clicking button to open the data from only the Ritalin row in copyformmedication  in a 2nd form  frmmedication.

However, -      Enter Parameter Value Window - opens instead
If I enter "2" into the window, which is the ID value in the medication table associated with Ritalin data  and  should be the same ID from the source qry for copyfrmmedication_lst, the Ritalin data opens correctly in frmmedication.

Please advise how I can get the correct result without opening the Enter Parameter Value Window. Thanks,
EETESTUSEVA.accdb
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Here you go ...
EETESTUSEVA.accdb
Avatar of PDSWSS
PDSWSS

ASKER

Thanks. Sometimes it takes someone else's eyes.

Only difference was  case -   Medication vs medication

Didn't know that queries were case sensitive.  Thanks again

Easy 500 points
<<
Didn't know that queries were case sensitive
>>

They aren't to my knowledge.

There was some other minor inconsistency that we both missed.  I copy/pasted the exact name in my earlier comment because I couldn't see where your criteria was wrong - so I wanted to get the table name exact without straining my old eyes any more looking for the typo. :)

But here is the database working with the M reverted to a lowercase m:
EETESTUSEVA.accdb
Avatar of PDSWSS

ASKER

After careful inspection there was a typo in addition to the case difference.
Avatar of PDSWSS

ASKER

Thanks for finding the typo. Sometimes can't see typos after looking at the same word for hours.
-->>>  After careful inspection there was a typo

Just curious what is was...?  I sure couldn't see it (but that parameter box was a dead giveaway that the spelling was off)
Avatar of PDSWSS

ASKER

Medicaton     should be Medication  

I must have looked at it 5 - 10x and finally gave up and sent it to you.