Selasa, 23 April 2013

[MS_AccessPros] Re: query criteria from open form

 

Well, evidently I corrected a small spelling error (my eyes just have trouble with those tiny characters) but after that was accomplished I am getting a query result with no records returned. The criteria I'm using is like this:
[Forms]![name of my form]![name of combo box]![name of field to return]

If I enter a valid ID into the criteria of my query it will return exactly the data I want.

--- In MS_Access_Professionals@yahoogroups.com, "ghsclass65" <dyspoz2@...> wrote:
>
> I'm trying to set up a query that will get it's criteria from an open form. I've set the query's criteria to the form's combo box and it's record ID, but when I run the query I get a dialog box "Enter Parameter Value". I thought the query would use the value from the record that was chosen in the form. No?
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar