Update record using Combo Box Selection

[efiftythree]

I am working on a database to record information about phone extensions on our phone switch. I have a table with three columns:

--------------------
| ID | EXT | INUSE |
|----|-----|-------|
| 1  | 243 |   1   |
| 2  | 192 |   0   |
--------------------

ID is the record ID, EXT is the extension number, and INUSE is either a 1 for used or 0 for unused.

I built a query that populates a combo box on a form with only the unused extensions. I want to be able to select an extension from that list and hit a button which will in turn update the INUSE field to a 1 for that extension in the table above.

I’ve searched and I can’t seem to find a starting point. Can someone point me in the right direction please Thanks!!!

 

[WildHare]

Very simple.

I'm assuming your combo has the ID field and the INUSE field as it's columns, at a minimum. If the BOUND column is ID, do this:

DoCmd.RunSQL "UPDATE your-table SET INUSE = 1 where ID = & your-combo-box-name

e.g.

DoCmd.RUNSQL "Update tblPhones set tblPhones.InUse = 1 Where tblPhones.ID = " & myComboBox

You need the ID field in your combo box so we can find the matching record in the table to update it. Got it?




"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman

 

[efiftythree]

Thank you WildHare. I am working on building the database portion up a bit then I am going to move back to the forms. I will let you know if it works. THANKS!!