Kamis, 29 Desember 2011

Re: [MS_AccessPros] Parameter Query Listbox

 

Report will work as well. How would I go about doing that?

Thanks

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi John,
>
> basing a form on a parameter query is not a good idea as forms are primarily used to change data.  See the code in the thread, "Filter a continuous form", which has been discussed today.  It shows how to set a form filter based on unbound criteria controls that the user can specify
>
>
> Are you wanting to display information only?  If so, a Report is best
>
> Warm Regards,
> Crystal
>
>  *
>    (: have an awesome day :)
>  *
>
>
>
> ________________________________
> From: yshopper
>
> I need to create a Form based on a Parameter query. The Parameter can be selected from multiple choices. Table tbl_Items has a Binding Status field that is a lookup from Table tbl_BindingStatus.
>
> I tried basing the query on just the Items table, but that did not work. I alos tried a query using both tables, but don't think I entering the Criteria correctly.
>
> I did find a way to do this w/o a Listbox, but would like to get this way to work.
>
> Any help or tips are appreciated.
>
> Thanks,
> John
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar