Updating table via fom (combo box)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 28 Dec 2007 16:15 GMT

I thought I had this problem licked but apparently not. My database has one
table with many columns including a combo box with two columns (supplier name
and supplier number) I use a form based on the table to update/enter data
into the table. What I want to accomplish is to select a supplier’s name in
the combo box on the form and have the table update the supplier’s name and
number in separate columns in the table. How do I accomplish this?

Thank you.

Reply to this Message

Wayne-I-M - 28 Dec 2007 17:02 GMT

Hi Joe

Looking at your post I "think" you may have a lookup field in the table.
Don't use these.

Make a back up 1st.

Then use a form to add details to the table (don't work on the table
itself). If you want you can use the wizard to create a combo on your form
and set the source as the field in the table you want to store the results.

Signature

Wayne
Manchester, England.

> I thought I had this problem licked but apparently not. My database has one
> table with many columns including a combo box with two columns (supplier name
[quoted text clipped - 5 lines]
> Thank you.
>

Reply to this Message

Joe - 28 Dec 2007 17:16 GMT

Thanks, Wayne. I will try your suggestion.

Joe

> Hi Joe
>
[quoted text clipped - 16 lines]
> > Thank you.
> >

Reply to this Message

Douglas J. Steele - 28 Dec 2007 17:24 GMT

Why? As in why would you want to store the data redundantly?

As long as you have the ID for the Supplier, you can look up the address
whenever you need it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I thought I had this problem licked but apparently not. My database has one
> table with many columns including a combo box with two columns (supplier
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message

Joe - 28 Dec 2007 17:41 GMT

Hi Doug,

Thanks for your response. Actually, I do not want to do redundant storage.
However, when I select the supplier's name from the combo box, it only saves
on the form and not in the column in the table. That is why I am looking to
see if I am doing something incorrectly. Any ideas?

Thanks.

Joe

> Why? As in why would you want to store the data redundantly?
>
[quoted text clipped - 12 lines]
> >
> > Thank you.

Reply to this Message

John W. Vinson - 28 Dec 2007 19:02 GMT

>Thanks for your response. Actually, I do not want to do redundant storage.
>However, when I select the supplier's name from the combo box, it only saves
>on the form and not in the column in the table. That is why I am looking to
>see if I am doing something incorrectly. Any ideas?

The table SHOULD contain only the ID.

It should NOT CONTAIN the name.

Tables are for data storage; for a field like this, what's stored is the link
to the table of supplier names. It is neither necessary nor prudent to store
the name in the table *at all*.

If you're routinely opening table datasheets to view or work with data...
don't. That's not their function! All interaction with data should be done
using Forms... where you *can* have combo boxes, extra textboxes displaying
names, etc.

John W. Vinson [MVP]

Reply to this Message

Joe - 28 Dec 2007 19:20 GMT

Thank you for you insight, John. As a point of clarification, I do not
routinely use the table or data sheet to view or work with info. My problem
here is simply trying to get the data entered into the form to save to a
particular field (supplier number) in the table, whch is not happening right
now.

Thanks, again,.

Joe

> >Thanks for your response. Actually, I do not want to do redundant storage.
> >However, when I select the supplier's name from the combo box, it only saves
[quoted text clipped - 15 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 28 Dec 2007 20:47 GMT

>Thank you for you insight, John. As a point of clarification, I do not
>routinely use the table or data sheet to view or work with info. My problem
>here is simply trying to get the data entered into the form to save to a
>particular field (supplier number) in the table, whch is not happening right
>now.

Well, that's not what you asked: to quote

What I want to accomplish is to select a suppliers name in
the combo box on the form and have the table update the suppliers name and
number in separate columns in the table

Do you have a Combo Box on the Form? What is its RowSource (post the SQL if
you would)? What is its Bound Column (the column which will be stored)? What
is its Control Source?

John W. Vinson [MVP]

Reply to this Message