how to update a field record based on inputbox?
Hello access friends,
Thanks for helping.
First of all, let me tell you that i have a form named "Processos" based on a
table named "Processos Rdinis", and this table has a primary Key named
"IDdeProcesso", a fiel named "Fechado" and another field named
"IDdeCandidatura". My question is how do i get an input box to update the
record on the field named "fechado" when i'm in the form named "Processos". I
need the input box to tell me the current state of the field, and to update
it if necessary.
The first part is working, i can see the present state of the field, but i
don't know how to update it.
this is the code that i have:
Private Sub botãodecomando_Click()
Dim Strg As String, SqlStrg As String
Dim Fechado As String
Fechado = Me.Fechado
Strg = ""
Strg = InputBox("Escreva Sim para Fechar o Processo." & vbNewLine & "Escreva
Não para Manter o Processo em Aberto." & vbNewLine & vbNewLine & "O estado
actual do processo está fechado?" & vbNewLine & Fechado, "Técnico BPO -
Rdinis")
End Sub
Thank you all for your help.
|