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) |
Tidak ada komentar:
Posting Komentar