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