Update Table column with dates based on From - To Value

[Ihussein]

Dears,
Please see attached table I'm try to update all the records of the table based on the above entered From - To Qnt, CmdUpdate on Click Event
Regards

[Gina Maylone]

Hi!

You can't put a command button on a table. Create an unbound form with unbound fields, "from" and "to", and "dateofreceiving". Create an update query using these unbound fields. I would have to know more about what you're trying to accomplish in order to give you further direction.

Hope this helps.
Gina

[Ihussein]

Thanks Gina,
I have developed sample database that might give more clarifications on the issue, I have created a form which has a a subform which displays the contets of my linked table in datasheet view. I can filter rows and reduce my visible records which it's working fine, user will enter QntFrom and QntTO and ReceivedDate, which is should update all the records within the specified range and move the update data to table (tblMontlhlyData) under field "DateReceived", and for the first textbox month of issuance will update field "MonthOfIssuance".
I'm attaching sample database hope it clarifies more.
Regars

[Gina Maylone]

UpdateTable2.zip
Good morning,

How do you want to calculate "QntFrom" and "qntto"? Do you want the numbers added to the existing numbers? I'm attaching what I would do (updating the info), I'm sure there are better ways using recordsets but I'm not adept with them. Hope this helps.

[Ihussein]

Good Afternoon,
Yes I fully agree with u, recordsets should my wayforward. but me to I'm not very well adept to it, and will take some time to be familiar with it, whoever I'm giving more explanations, mean time I will further explore for VBA recordsets.
In addition to above post the "QntFrom" and "QntTo" are the number that I entering so that updatelist button will update only the records that have been selected.
ex.
let us say for the month of issuance I entered November-2015
filter location Name "Central State" and
QntFrom = 10
QntTo= 12
DateReceived = 11/Nov/2015
then it should update records as per the attached screen.
Note:instate of choose I want it to display date of received which is in my case is 11/Nov/2015. hope it clarifies.
Once again thank you so much Gina for initiate and the support, much appreciated. Regards