Validation Rule

[MdHaziq]

Hello


Forum,

I have a button in my subform, [Forms]![frmLog]!, that has an edit query to my master form, [Forms]![frmMaster]. I have a validation rule for one of my controls, [Forms]![frmMaster]![CurrentQty] >= [Forms]![frmLog]![UserQty].

When I click on the button it prompts and does not edit my qty but the validation message is not what I wanted when I set it in [Forms]![frmMaster]![CurrentQty] validation text.

Can someone help me out, please?

TIA

Haziq

[davegri]

MdHazia-ECD inv DB for 26Dec-v1 .zip
The update query that you had will update every record in tblMaster, as it has wrong criteria specified.
Try the above attachment. I got rid of the macro that called the update query (you can delete that query), and put the correct update query syntax
in the button_click event for the log form which uses currendb.execute to run the query string.
You will probably want to edit my code to prevent a withdrawal that would result in a negative quantity.

Your project will not compile clean as you have several syntax errors in the code.

[June7]

Saving calculated data especially aggregate data is usually a bad design. Aggregate data should be calculated from transaction records.

[MdHaziq]

Thanks guys for your help.

June7, I will work on using transaction records for aggregate data.

davegri, thanks for the code!