View Single Post
  #1  
Old May 14th, 2010, 11:04 AM posted to microsoft.public.access.forms
puppetmint
external usenet poster
 
Posts: 1
Default 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.