ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 4,564
- Office Version
-
- 2007
- Platform
-
- Windows
Morning.
I have a database which stores customers info. Each horizontal cell has a drop down list where i select the required item.
Upon pressing a button the userform opens. I can then browse through each customer thus showing me all the completed text boxes with info that I selected on the database.
Currently it's only a way way thing in that I mean I have no option in the userform to click a text box and select from a list of items. But I can click a text box and type something & then upon clicking save this customer is then added to the database no problem. Is it possible to have a two way setup so that on the userform there is an option to select from the same list as where I select on the database. This then would make the cell contents the same as currently on the userform you just type from memory of what you think was in the drop down list on the database. With me in this ?
Many thanks.
I have a database which stores customers info. Each horizontal cell has a drop down list where i select the required item.
Upon pressing a button the userform opens. I can then browse through each customer thus showing me all the completed text boxes with info that I selected on the database.
Currently it's only a way way thing in that I mean I have no option in the userform to click a text box and select from a list of items. But I can click a text box and type something & then upon clicking save this customer is then added to the database no problem. Is it possible to have a two way setup so that on the userform there is an option to select from the same list as where I select on the database. This then would make the cell contents the same as currently on the userform you just type from memory of what you think was in the drop down list on the database. With me in this ?
Many thanks.
