Parameter Misery

[Guest]

I have a DB that has had no problems for a year. Now I am being asked for a
Parameter where a query is looking for a field on a form. The field is acombo
box where you pick a date that has been added to box (table) on a monthly
basis.
When I enter the date/time by hand the query finds the data.
When I enter the date/time into the paramter, the query finds the data.
But if I leave the equation, in table view, the fields are blank.
I have added the DAO 3.6 libraery, it was missing but it has not solved the
problem.
Help!

 

[Guest]

Someone changed the name of the field in the table; the form name; or the
combo box name.

It's also possible that you need to add the value argrument to the parameter
in the query. Something like:

[Forms]![frmParameterCombo]![cboVendor].[value]

 

[Guest]

Dear Jerry,
I tried the .value and it 's the same story. A blank data page, but if I
paste in the date/time value,in the parameter box, my data will show.
I went into the documentor and was able to bring up the Form. So I know it
hasn't been mispelled. I have tried reconnecting it many times. It should be
an easy problem, but it isn't. I have even put a new combo box on the form
and tried to link it to the query. Same story.

Someone changed the name of the field in the table; the form name; or the
combo box name.

It's also possible that you need to add the value argrument to the parameter
in the query. Something like:

[Forms]![frmParameterCombo]![cboVendor].[value]

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a DB that has had no problems for a year. Now I am being asked for a
Parameter where a query is looking for a field on a form. The field is acombo
box where you pick a date that has been added to box (table) on a monthly
basis.
When I enter the date/time by hand the query finds the data.
When I enter the date/time into the paramter, the query finds the data.
But if I leave the equation, in table view, the fields are blank.
I have added the DAO 3.6 libraery, it was missing but it has not solved the
problem.
Help!