I know there are guides but i have used them and still cant get it to work, so can someone please help me, i have created a category form, and a query, but when i create the code in the query it doesnt seem to work, can someone please either explain it to me, or see where i am going wrong
It looks to me like the combo box on your query-by-form form is giving the numeric category ID while tblBook and the query based upon it actually uses the longer category description.
And here's something I put together that may give you some ideas about making time periods and other criteria dynamic.
The free downloadable sample database at www.Bullschmidt.com/Access uses the query-by-form concept so that on the invoices dialog one can optionally choose a rep, a customer, and perhaps a date range, click on a button that says "Input," and then have the invoice form open up showing all the invoices that match the criteria.
Well the other way to go would be to have the new form show the category names instead of the category ID's. At any rate the table and form should be in tandem both using category ID's or category names...