Entering Records to a table using an Unbound Form

[Woftysofty]

Access 2007 gurus, please help!

I have a table that I want to add new records to from an unbound form.

I have been looking everywhere for some VBA sample code that would help me to do this but can't find anything useful.

I want to use an unbound form not a bound form!

Can somebody please help me with this!

 

[pbaldy]

You would either use AddNew with a recordset, or execute an append query that got its values from the form.

 

[Woftysofty]

Thanks pbaldy for your efforts on this matter.

You wouldn't be able to give me a simple example of a piece of code that you would write if you were to do this with the recordset option could you.

I would really appreciate it.

Thanks again!!

 

[pbaldy]

A brief search turned up:

http://www.access-programmers.co.uk/forums/showthread.php?t=52425

though you don't need the multiple records part.

 

[Woftysofty]

pbaldy, thanks again!

I finally figured it out thanks to your guidance.

Works great!

 

[pbaldy]

No problemo, and welcome to the site by the way!