Save information to a table from an unbound textbox

[charly.csh]

Hi everyone,

Into my form called "Form1" there is two unbounded Textboxes (not related to the original table - "main1tbl") called "TextBox1" and "TextBox2" and also a command buttom called "Savecmd".

The event I would like to create is "Savecmd_Onclick" and when the users would type information into "TextBox1" and "TextBox2", and then after click on "Savecmd" that information would be saved into the table "Recordtbl" at the fields "Field1" (TextBox1) and "Field2" (TextBox2)



Could somebody help me on this with the code?

I really appreciate your help!

[Homegrownandy]

Just bind the text box mate. make sure your fields are included in the data source of your form. then select the field you need in the text box.

[RuralGuy]

Does the form use the Recordtbl table as a RecordSource?

[charly.csh]

No, in fact the table Recordtbl is independient from the form1 and from the table "maintbl"

[ItsMe]

There are a couple things that need to be clarified. First, are you trying to append a record to Recordtbl or are you trying to UPDATE an existing record within Recordtbl? If the latter, you will need to define which record by including criteria on your VBA statement.

If the former, you could use an SQL statement to INSERT INTO.

Something like

dim strSQL as string
strSQL = "INSERT INTO Recordtbl (Field1, Field2) VALUES(" & Me.TextBox1 & ", " & Me.TextBox2 & ")"
currentdb.execute strSQL

[charly.csh]

I would like to append the information, I tried with the code but it shows an error on "currentdb.execute strsSQL"

[ItsMe]

The code I provided is for Numeric values. Here is a text version
strSQL = "INSERT INTO Recordtbl (Field1, Field2) VALUES ('" & Me.TextBox1 & "', '" & Me.TextBox2 & "')"

[charly.csh]

That is exactly what I was looking for!!!

I really appreciate your help!!!!

[ItsMe]

No problem. It is advisable that you add some code to verify there is actual data in the textboxes before attempting the append and that the append, if that line is executed, was a success. Writing code to do stuff is the easy part. The big job is writing code to make sure everything is running smoothly.