Update record selected in a comboBox from a button (2 Viewers)

[Tom d]

I want to update the selected record in a comboBox from a button not add a new record. I can add a record and delete a record.

 

[Pat Hartman]

How many threads do you have going on this topic? You've been given lots of advice. I even posted a sample db for your review. Starting new threads this way will not increase the help you get. It will keep people from responding.

 

[Tom d]

How many threads do you have going on this topic? You've been given lots of advice. I even posted a sample db for your review. Starting new threads this way will not increase the help you get. It will keep people from responding.

All the other treads are marked Completed. Nowhere does any attached file show how to update a record. IF you have any that shows how to update a record please attach.

 

[Pat Hartman]

IF you have any that shows how to update a record please attach.

Your design is all wrong. I suggested an alternative AND it shows how to update the selected record.

 

[MajP]

This can be done lots of ways. If you are talking the Authors form you have plenty of real estate to have a the name field as a bound control on the form. It could be hidden until a vaule is selected from the combo. You could simply bind the whole form to the authors table and have a textbox with the author name as the control source. When you select from listbox it moves to that author. Then allow the user to edit the textbox. On the combos on entry event requery the combo.
Or you could make it a dialog pop up. Open the pop up to the correct record selected in the combo and open acdialog to stop code execution. Then in the next line of code requery the combo.

 

[Tom d]

This can be done lots of ways. If you are talking the Authors form you have plenty of real estate to have a the name field as a bound control on the form. It could be hidden until a vaule is selected from the combo. You could simply bind the whole form to the authors table and have a textbox with the author name as the control source. When you select from listbox it moves to that author. Then allow the user to edit the textbox. On the combos on entry event requery the combo.
Or you could make it a dialog pop up. Open the pop up to the correct record selected in the combo and open acdialog to stop code execution. Then in the next line of code requery the combo.

Could you give an example.

 

[MajP]

You want a pop up or a on the main form?

 

[MajP]

Use the update record on the Authors form.

 

[MajP]

You may want to look at this example of having a single lookup list to manage these simple lookups. Unlikely to support a large list like authors, but OK for the rest.

Listbox with just 3 or 4 items I would like to easily add/remove & saved. ValueList would be nice, perhaps avoid tables & subforms?

Hi, I cannot work out the best/simpliest way to do this. I would like a listbox on my form, So I can easily add or remove items directly by clicking on the listbox for ease & clarity. value list is almost perfect but v.occasionally might want to change those items and that data is not saved...

www.access-programmers.co.uk

 

[Tom d]

Use the update record on the Authors form.

Use the update record on the Authors form.

Thank You. It Works