Running Query on only 1 row of table.. Criteria?

[JMac]

Hi All
I want to avoid updating the entire table when running a query.

Basically the front page form of my DB is a series of drop down lists which populate a table, thats easy.
When the user has chosen each drop down field I ask them to press a command button which runs a query that adds (&) all their choices for the specific record into the nominated column, I have completed this sucessfully...

However, it performs the query on every record in the table and after a while, when the DB is large, I suspect this would become a little difficult to handle.

My thoughts are it should be a criteria statement limiting it to work on only the last record but Im unsure of the expression to use...
Any thoughts??

Thanks

[June7]

Yes, use WHERE clause in the SQL statement.

What do you mean by 'all their choices for the specific record into the nominated column'? Are you saving multiple data as a single string to a single field?

Why is it necessary to run an UPDATE query if you only want the data in the current record?

Do you want to provide project for analysis? Follow instructions at bottom of my post.

[JMac]

There are 5 boxes on the form, each with a drop down choice, from look up tables containing 6 items plus an auto number. (these look up tables will eventually have more options which is why they are seperate)
When the user picks or rather populates all the 5 drop down boxes on the form (plus autonumber) I want to fix those 5 choices + 1 auto number and enter the result it into the 7th column... and thats the new record
So
Drop down look up box 1 options are: Black, Green or Red
Drop down look up box 2 options are: Extra large, Large, medium or Small
etc etc
They make the choices then press the Save button (which runs the query) and that record is stored

So the format of the query for choices Green + extra large + etc etc = GXL+(Autonumber)
And this is saved as a unique record...
Then the next entry is a new record and may well be the same but its got an incremented autonumber making it unique...

[June7]

You want to create a unique ID with the choices of the 5 comboboxes? The comboboxes are bound to fields of form RecordSource? So you are saving not only the individual choices in each field but also the composite ID? Not something I would do.

If the form is bound to the table you want this record created in, then saving the composite ID could be as simple as:

Me!fieldname = Me.cbo1 & Me.cbo2 & Me.cbo3 & Me.cbo4 & Me.cbo5

[JMac]

You want to create a unique ID with the choices of the 5 comboboxes? Yes, however they can never be duplicated which is why the autonumber is also added in
And this unique ID needs to be printed out, attached to the item physically and recognized visually whilst not containing every bit of info. The full details will be entered into another form which will then in future be able to be ammended, which is why I want to keep the part number table separate.

The comboboxes are bound to fields of form RecordSource? Each combo box is linked to its own separate table which displays the descriptions but embeds a code (second column) rather than the full description, each of these look up tables will grow in size over time

So you are saving not only the individual choices in each field but also the composite ID? Yes, because there are multiple items of the same spec, so I need a visual identifier firstly but something which distinguishes between similar items also. The ID is created to only be used to identify, that unique ID will then be used in a more comprehensive table with the exact details of the item...


If the form is bound to the table you want this record created in, then saving the composite ID could be as simple as:

Me!fieldname = Me.cbo1 & Me.cbo2 & Me.cbo3 & Me.cbo4 & Me.cbo5 Would this work if the incremental autonumber is added on the end to get 'uniqueness'?

[June7]

Yes. Might have to save the record before can reference the generated autonumber value.

DoCmd.RunCommand acCommandSaveRecord

And if it is the description in second column of each combobox that you want (column index starts with 0):

Me!fieldname = Me.cbo1.Column(1) & Me.cbo2.Column(1) & Me.cbo3.Column(1) & Me.cbo4.Column(1) & Me.cbo5.Column(1) & Me.ID