Simple Form Qestion

[wardy]

Hello All,
this is my first post on the forum, so thank you all in advance for your kind help,, and please bear with me as i'm quite new to this,,,
i have put together a very simple database in Access, it consists of one table that contains about six fields (columns), i have a form that represents the data in the table,, all good so far,, i have some boxes on the form that link back to the table,, this is where i'm getting confused,, i have added a combo box that links back to the table, this combo box works fine as it represents the data in the table, the data in the combo box is currently the only data in the table,, what i would like to do is use the form to add data to the table,, the problem is that when i change to a different record using the combo box and add data to the other boxes through the form, that data is never 'saved' or 'written' back to the table,,, hope this makes sense
is this easy to fix
thank you all very much for your help
best regards

 

[statsman]

The simple solution is to open the Properties on the form. Change "Data Entry" to Yes. You will be presented with a blank form and you can enter the new records. They should be saved automatically. The down side is you will only be able to enter new records on this form. You will require separate forms to edit or view the records.

If you wish to use 1 form for all uses, do not set the Data Entry to Yes. Place a Command Button on the form set to "Save Record". Each time you enter new data you will have to click the Save Record button.

 

[qdogfball]

Wardy,

I usually will add a 2nd table that houses the items for my drop downs, combo boxes, etc.

That way, I can change the table so that if I need new items to choose from, that can be done easy. I can also setup an new form that will allow me or others to add to the combo boxes (Even Gasp! an end user! )

So, with such a system as you have, I would setup a relationship through the Tool bar wizard;

Create a table with the items for the combo box. Just one field in this case.

Then back in your form, click on the combo box button on the tool bar.

Click where you want the combo box at on the form.

Select "I want the combo box to lookup the values in a table or query."

Click Next, then find your table of combo box items.

Click Next, add your combo box fields (should be just the items you want in the box) Click the > to put in selected fields.

Click Next, Asks for Sort order. Do if you want.

Click Next, Give it a width.

Click Next, Store that value in this field. This is where the combo box value is stored in the original table.

Click next, Give the combo box a name. and your finished!