DataBase

[Slimak]

here is my question:
http://www.vb-world.net/ubb/Forum1/HTML/005847.html

Thanks for your help
SLimak

------------------
Marek Karbarz
My WebPage (http://www.angelfire.com/mb/slimak)
Zarembisty@aol.com

[preeti]

Hi,

Do you mean you want to save an empty record into your database

- OR -

Users will enter data, then you save the information that the users entered?

Preeti

[Slimak]

The second option

------------------
Marek Karbarz
My WebPage (http://www.angelfire.com/mb/slimak)
Zarembisty@aol.com

[preeti]

Hi,

All you have to do is:

Dim SystemDb As Database
Dim SystemRs As dao.Recordset
Dim SQLStmt1 As String

Set SystemDb = Workspaces(0).OpenDatabase(App.Path & "\databasename")

SQLStmt1 = "Select * From tablename"

Set SystemRs = SystemDb.OpenRecordset(SQLStmt1, dbOpenDynaset)
With SystemRs
.AddNew
SystemRs![Field] = textbox1
SystemRs![Field] = textbox2
SystemRs![Field] = textbox3
SystemRs![Field] = textbox3
.Update
End With

Hope this helps,

Preeti

[Slimak]

Thanks !!!!!!!! :) :D

------------------
Marek Karbarz
My WebPage (http://www.angelfire.com/mb/slimak)
Zarembisty@aol.com

[ScottF]

I may be way off but what the question mean to me is that you want your bound text to be empty when the form loads.
Private Sub Form_Load()
text1 = ""