If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|