adamskiii,
Why have you created an "unbound" form to operate on a table?
If you're new to Access, you've just made your project much more
difficult than it needs to be.
You'll need to create a button on your form that, when clicked, runs
an Append query against your table, using the current values on the open
form.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
You would probably open the recordset and write the values from the form to
the table for example:
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
With rst
.Open "YourTable", CurrentProject.Connection, adOpenDynamic,
adLockOptimistic
.AddNew
.Fields("tablefieldname") = Me.textboxonform
.Fields("tablefieldname") = Me.textboxonform
.Fields("tablefieldname") = Me.textboxonform
'etc...
.Update
.Close
End With
Set rst = Nothing
replace the "tablefieldname" with the names which you use in the table for
your fields
Replace the "Me.textboxonform" with the names of the textbox controls you
are using on your form.
What kind of backend are you using? I assume this is an MSAccess database as
nothing has been noted otherwise... if this is in fact the case, then there
is no reason whatsoever to be using any recordset an all, let alone using ADO!
As Al said, you are going the looooooong way around. If you have a standard
ms access table and form, just use the wizard to make a form that is bound,
and all of this is taken care of for you (using Access's native DAO, not ADO).
Sure, but that means that you must do Every Single Little Thing that Access
does for you automatically. Unbound forms are in fact useful; they are also
slower, much more complex, and far more difficult to create and maintain. Your
choice!
adamskii,
What "control" would that be... that couldn't be done on a bound form?
And... how do you plan to edit or delete your existing records?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
