I am trying to enter 5 peices of Information and with this information Access
then Adds to a table that has 16 fields in it. I am not sure how to proced.

Randy,

Start by creating a form. Put your 5 text boxes (or combo boxes, etc) on
the form. Then put a command button on the form. In the OnClick event of
the combo box you'll want to write code something like the following:

Dim db as Database
Dim rs as Recordset

Set db = CurrentDb
Set rs = db.OpenRecordset("MyTable", dbOpenDynaset)

rs.AddNew
rs!Field1 = MyTextBox1
rs!Field2 = MyTextBox2 'etc.
rs.Update

Set rs = Nothing
Set db = Nothing




"Randy" <(E-Mail Removed)> wrote in message
news:38906853-FA97-4E00-8CB7-(E-Mail Removed)...
>I am trying to enter 5 peices of Information and with this information
>Access
> then Adds to a table that has 16 fields in it. I am not sure how to
> proced.

On Tue, 21 Oct 2008 09:05:01 -0700, Randy <(E-Mail Removed)>
wrote:

>I am trying to enter 5 peices of Information and with this information Access
>then Adds to a table that has 16 fields in it. I am not sure how to proced.

Simplest would be to just create a Form based on the table. Enter the five
values you want added on the form; Access will automatically save the record
to the table when you move off it or close the form.

You don't say what the sixteen fields are, whether they're required, or what
they have to do with the five fields you're adding, so I'm not certain this
adresses your question!
--

John W. Vinson [MVP]