I have a problem working with MS Access. There is a table named "40" and a form that fills that table "40 valdymas". In that form combobox "Pavadinimas" fills the table field "Pavadinimas". I need to add a possibility to specify amount of each SELECTED combobox item (for example, 2 of Oligochaeta, 5 of Scorpiones) and expression in table field "Pavadinimas" should be exaclty: 2*Oligochaeta, 5*Scorpiones etc.
I am not sure whether the problem is explained correctly, but I can try to clarify if it is needed. I would be very thankful.
Screens:
![]()