Hi everybody, I am new to Access so bare with me pls.



I am creating a hotel based project for school in Access and I am having a problem.

I have a table "Room" PK Room# and another attribute called Room Status. Under Room status I have options of Occupied-not yet cleaned, Occupied- cleaned, Checked out- not yet cleaned, and Available

What I want on my form is to have each combo box for each room to grab the correct data from the Room table relating to the correct room and be able to update it on the same form. Attached is a screenshot but it lacks functionality. I just took them to explain my problem. The first shot should be of the current Room table and the second shot is when I change Room #1's status from Occupied- cleaned to Available and then I click update to save it in the Room table

Any help would be awesome.


Solved NVM

TIA

-Traction-