I need help on what method to use for the DoCmd when i want to query from another table A, and output its content to the form after increment it.
I have this stmt :
If Me.EQP_CAT_ID.Value = CPT Then
If the selected option from combo is CPT, then it will query from Table A and increment the value of Field1 and output the value to the form. How do i get around with this?
Thank you.
I have this stmt :
If Me.EQP_CAT_ID.Value = CPT Then
If the selected option from combo is CPT, then it will query from Table A and increment the value of Field1 and output the value to the form. How do i get around with this?
Thank you.
