Well I got this code on a subform in a checkbox.
What it does is when I click it, It will automatically get a field value "Shipment" and asign it in the database.
Que "chkBOX2" and make it False.
Requery
And Requery the other subform.
What I want to do is that when I click it instead of getting the value inside Shipment field it Prompts a box asking what value I want to introduce in the database for that records.
Anyone?
Thanks in advance.
Code:
Private Sub SalidaAlmacen_Click()
Me!SalidaNum = Forms!MYFORM!("[Shipment]").Value
Me!chkBOX2 = False
Me.Requery
Forms!MYFORM!MYSUBFORM2.Requery
End Sub
What it does is when I click it, It will automatically get a field value "Shipment" and asign it in the database.
Que "chkBOX2" and make it False.
Requery
And Requery the other subform.
What I want to do is that when I click it instead of getting the value inside Shipment field it Prompts a box asking what value I want to introduce in the database for that records.
Anyone?
Thanks in advance.