I'm attempting to create a form that will add information to a cell in the table when a Command Button is selected. I'm probably missing something very simple. Can you help?

(IMG:style_emoticons/default/crazy.gif)

Thank you,
Betsy

Hi Betsy,

(IMG:style_emoticons/default/welcome2UA.gif)

What version of Access are you using? Knowing the Access version may help us determine a more appropriate response to your question.

Why do you need a button for that? Is the table different from the one that the form is using? What exactly are you trying to accomplish?

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

I'm using Access 2007. I'm trying to create a form for inputting quality control informatiion. I have a list of errors with codes and associated values. What I'm trying to do is create a control button that when clicked will insert the error name, error code and point value into the table in each cell assigned. Am I asking for too much?

Hi,

The only reason I asked is that you don't normally need a button just to save a record to the table because an Access form will already do that for you, automatically. So, putting a button to do the same thing that Access already does right off the bat is merely redundant.

When you create your form, just make sure the textboxes are bound to your table fields and Access will take care of the rest for you.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

That's not quite was I was asking. I have 2 linked tables. One table has the basic statistics related to a mission (# of targets, # of products, etc), the second table, linked by mission #, has the quality control information (how many products were checked for errors and what errors were observed per products). What I'm trying to create is a form that will automatically set the values of the QC table when an error is identified. Does that explain it better?

Hi,


Not entirely, without knowing anything about your business process.

This is probably not what you want either but the usual way of handling records from two related tables is by using a form/subform setup. Again, Access will do a lot of things automatically for you if you use this setup, such as Access will automatically add the foreign key to the child table every time you add a new record in the subform.

To get a more specific suggestion, you might want to describe to us your table structure and the purpose of your db.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)