Ask Value for subform Entry via Prompt box?

rodvaN

Registered User.
Local time
Today, 11:35
Joined
May 20, 2009
Messages
92
Well I got this code on a subform in a checkbox.
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.
 
Look at InputBox in VBA help.
 

Users who are viewing this thread

Back
Top Bottom