Record selection in subform

[N1755L]

Hello everyone, I have a form that shows multiple rows of linked/child records (I know there's better jargon to describe what I'm trying to explain here, but I'm a bottom-rank amateur at MSAccess and don't know the lingo yet, sorry).



The form in question is the "frmFilterNumberTypeView" form. When a particular filter is used (installed on an automobile), I would like to be able to click on the corresponding "Installed 1" button left of the filter number, so that by code, I can reduce the Qty on Hand by One, and insert the corresponding filter ID to the History table, along with the date/time the filter was used.

I'm not asking how to reduce the Qty on Hand, nor how to do the updates to the History table, I'll figure that out myself over the next week or two (hopefully it won't take that long). What I'm trying to figure out here is how I can associate the red "Installed 1" button with the filter to the right of whichever button I press.

I just have absolutely no idea how to go about figuring this one out, or if it's even possible. Is it? In design view there is only one button with one name (cmdInstalled), but this same button seems to exist many times over in the subform, so I'm at a loss as to how I'm going to code so that the filter number record immediately to the right of whichever red button I push is the same record that is going to be updated/sent to the history table, so that I can keep track of which filters have been used and on which dates.

Thanks.



Little side issue... I can't seem to figure out how to sort the filter column on this same form. I'm fairly certain that this would be very easy to do if the subform in question was populated by means of a corresponding query, but I'm afraid that if I go that route that I'll spend another 20+ hours trying to figure out how to get the proper filter records to match the filter manufacturer, not to mention having to next figure out how to link the table so that if I modify any particular filter record, that I'll be able to have the associated table update accordingly.

Is it possible to sort the filter column without the subform record source being a query?

[June7]

Conventional relational database wisdom is to not save calculated data, especially aggregate calcs. In other words, should not adjust a quantity on hand value in table, this value should be calculated from raw data records.

The buttons exist many times because there are many records, just as the textbox and combobox must replicate for each record, the buttons will replicate. All controls in the detail section will replicate for each record.

I just tested code in the button click event. It read the value of the ffilternumber field for the record the button is in.
Debug.Print Me.fFilterNumber

Can sort subform by setting its Order By property.

Or by right click on any field to open shortcut menu

[N1755L]

Conventional relational database wisdom is to not save calculated data, especially aggregate calcs. In other words, should not adjust a quantity on hand value in table, this value should be calculated from raw data records.

...

I just tested code in the button click event. It read the value of the ffilternumber field for the record the button is in.
Debug.Print Me.fFilterNumber

Thanks June7, I am only saving the filter unique ID and the date it was used in the History table. As you mention, I will later be able to calculate how many of a particular filter have been used and when. The idea is that I would have code for the Installed button that would update the FilterNumbers table, reducing the QtyOnHand field value by 1 every time the button is pushed. I'm not certain how any particular replicated button is going to associate with a particular record, but am going to test that Debug.Print.Me you mention and see if I can figure this out.

As for the subform Order By property... duh... sorry, had no idea this existed. Thanks, that's EXACTLY what I was hoping for. I knew I could do it by way of context menu, but wanted it "permanent" as your suggestion will achieve.

Thanks again!