Qry from a Table

[wjm821]

How to you get to the bottom of the table. Example with a form [Forms]![MainForm]![MainName.cmbobox(1).
My table tblProduct has ProductID, ProductName,ProductCost. Under ProductName there's a list P1, P2,P3,P4. In my qry I need to pull P1. Im stuck. Code I have [tblProduct]![ProductName]! ((( how to get P1)))). Thank you

[kd2017]

It's still not clear to me what you are really after... But the SQL code below should be a direct answer to your example question.

SELECT ProductID, ProductName, ProductCost FROM tblProduct WHERE ProductName = "P1";

Here is a query that will grab all the records and sort them

SELECT ProductID, ProductName, ProductCost FROM tblProduct ORDER BY ProductName ASC;

To sort in reverse order use DESC instead of ASC. In fact the ASC is optional, sorting is assumed to be ascending by default.

But I assume you are using a form, in that case it's better to leave the sorting to the form by using the Order By property of the form.

If you are trying to open a form to a specific record you would use DoCmd.OpenForm

DoCmd.OpenForm "FORM_NAME_HERE", , , "SEARCH_CRITERIA_HERE"

Making assumptions from the code you've posted above that would look maybe something like this

DoCmd.OpenForm "FORM_NAME_HERE", , , "ProductName = '" & Me.cmbobox & "'"

Finally, if it is that you are trying to reference a combobox on a form from a query then it might look like this:

SELECT ProductID, ProductName, ProductCost FROM tblProduct WHERE ProductName = [Forms]![MainForm]![cmbobox];

[mike60smart]

Hi

These fields in a table P1, P2,P3,P4 are known as Repeating Groups.

They should be Records in a Related Table

Can you upload a zipped copy of your Db?

[Micron]

Hi

These fields in a table P1, P2,P3,P4 are known as Repeating Groups.

They should be Records in a Related Table

Can you upload a zipped copy of your Db?

Those are records/values in ProductName field?

Under ProductName there's a list P1, P2,P3,P4