Saving in a new record

  • Thread starter Lipoio via AccessMonster.com
  • Start date
L

Lipoio via AccessMonster.com

Hello i know it might sound a little bit too easy but i just can´t find the
way of saving some information in a new record of a table. I have a form with
some combo boxes and lists with filled information. When preessing a command
button i want to save this information to a table1. each combo box in an
specific field. I dont know if there is an specific command or how can I get
these values written in a new record in my table. I would appreciate some
advice.
 
J

Jeff Boyce

Provided that the form is bound to the table, and the controls (e.g.,
comboboxes) are bound to the fields, you can explicitly save using a command
button (and you can use the command button wizard to create this), or you
can simply move to a new record. Leaving a record in Access saves it.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
L

Lipoio via AccessMonster.com

I have already a command button, I tried this expresion on the click event
module:

insert into Table(, proceso) value(combo0.Value, combo3.Value);

I have used these code invisual basic programing but I just can´t make this
work in Access.
 
R

Roger Carlson

Is this a bound form (that is, does it have a table, query or SQL statement
in the Record Source property) or is it unbound? The code you are
attempting to use is for an unbound form (which a lot of VB projects use).

If you want to continue to use it as an unbound form, you might want to look
on my website (www.rogersaccesslibrary.com), for a small Access database
sample called "UnboundSQL.mdb" which illustrates how to do this.

However, if you just add a table, query, or SQL statement to your form, you
can use it as a bound form and saving is as simple as moving to a new
record.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
L

Lipoio via AccessMonster.com

Wow it was quite helpful . There were unbounded objects so i have just solved
my problem thanks a lot!!!!!!
 
Top