Search Result

Hi
I am using Access 2010 and trying to get the results from a query to display each record in a seperate text box in a form.
My query runs from ComboBox1 After_Update in the form with no problem and leaves the results of the components of a diesel car, petrol car or van.
What I would like to happen is After_Update of ComoBox1 is the resulting records to be displayed in the form like a list with a checkbox next to the list so...

In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber) which is an autonumber field.

In detail view of my form, I select the upper left corner black box properties to get to:

Form - Properties
Record Source - Table1
Order By - Table1.InvoiceN umber

As the field...

Hi,
I created a database with a table that has customer info - including sales history. I want to create a form so that i can search based on various criteria (first name, last name, purchase date, etc.). I was able to create a form and tried adding a command button to search records but it only looks at the field where my cursor is and only returns the first record that it finds. How can i add a search button that will search an entire database...

How make some rows of a Form fully locked for edit based on criteria?

Let's take two fields Date (criteria), Qty (editable).
I will list all rows where Date is between DateFROM and DateTO.
Now I want to be able to edit only fields where Date>DateTO-5.

Is there property to lock selected rows of displayed data in the Form DataSheet View. I guest I could do it with VBA in Single View but that's not the...