Search results

Oops, Just fixed that. CustomerID should have been TransactionID. Now the search works for the most part. Thanks

I now get an error "Data type mismatch in criteria expression" One thing I noticed was that it doesnt matter which record I select it always come up as the first record in the table.

Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerID] = " & Str(Me![QuickSearch]) Me.Bookmark = rs.Bookmark

Sorry, I tried using the same idea in my form. I have a form that someone can enter a new record or modify an old one. I would like them to be able to search for a older record so they can modify it.

:o No help??

I have implemented the search function in this datebase Search02.zip (found here http://www.access-programmers.co.uk/forums/showthread.php?p=319650#post319650 ) I am having one problem. The Search works fine, but whenever I click in the list box for record to be brought up nothing happens...

I have deleted and then created a new combo box with the wizard and the outcome is the same.

bump :eek: ttt

I have a form where the user selects a Customer from a combo box, then the user selects a Product from another combo box. The rowsource in the Product Combo Box set to SELECT tblProduct.ProductID, tblProduct.Description FROM tblProduct WHERE...

Sure, Lets say I have 3 reports. Each report could have 1-4 pages printed. I want to use a Form with a button so print this all out. -------------------------------- Situation A Report Food - 3 Pages Report Weight - 2 Pages Report Check - 4 Pages Total Pages = 9...

I have 10-15 reports at a time that I want printed from a form as a set. 2+ copies of each report may be required. How can I number the pages correctly? thanks -ryan

I tried all that and I get an error of " You entered an expression that has no value" I dont think I explained my problem very well. I have a field in a combo box type display on my report, and I would like to enter it into a label string. thanks for the help. -Ryan

I have a combo box called cboWeightCheck and would like the selected value to be put into the middle of a string for a Label called lblProd. Whenever I think im close to figuring it out and I run the report Access crashes on me. thanks -Ryan