Enter Parameter Error

[Navyguy]

Hi All

Well I cannot believe how much I have forgotten over the years... I have a couple of simple problems that have gotten the best of me. I have read literally hundreds of posts and searched dozens of times; even found the exact issues I am having and I still cannot resolve them...

Need to call in the Calvary I guess.

I have attached a .pdf to show what I am experiencing (picture is worth a 1000 words right?)

Same form, same combo boxes, etc, two different errors and I am still not sure if the combos will work after I get the errors sorted out...

The form is unbound, user selects the Equipment ID Number (Unique Number) and it provides options for Motor Serial Numbers to select. The intent is once the selection is made the user will select the GO TO button and a report will be published displaying all the maintenance information on that particular motor.

One Equipment ID Number (from a possible list of 100s) and one or more Motor Serial Numbers filtered on the selected Equipment ID Number.

Any assistance would be appreciated.

Cheers

 

[pbaldy]

Since the field is text the value needs to have delimiters, like:

...Equipment_ID_Number = '" & Me.Cbo_Equipment_ID_Number & "' ORDER BY Motor_Ser_No"

 

[Navyguy]

Hi Paul,

Thanks +10 you... I knew it was something so simple... I wish I could get my day back now... any help with that!!!

Cheers

 

[pbaldy]

Happy to help! But you should know I'm an Air Force dad!

 

[Navyguy]

Well now that I know that, I will have to give you a few more "Thumbs up"...

Anyone who admits publicly that they are an Air Force dad must be a pretty solid guy

Sic Itur Ad Astra

Cheers