Supply Request UserForm to Update Supply Inventory

[DKamins]

Hello,

I am creating a userform for employees to request office supplies. Their requests creates one database so we can see how many supplies are being used, and which departments have the greatest needs.

I have another database of the supply inventory that I would like to be instantly updated with each supply request so that we can tell in real time when we are low on a particular supply.

I have created the userform for requesting the supplies, and have created an inventory database....I'm just not sure how to link the correct fields from the supply request database to the inventory database cells to be updated....anyone have any ideas for me

Thanks,
Del

 

[Smitty]

Welcome to the Board!

This kind of thing is much better done with Access. Is that an option?

 

[DKamins]

Hmmmm, I thought about doing it in Access, but I am sooooo much better at Excel than Access...that said, I will hope someone can help me here, but meanwhile I will take your advice and see what I can do in Access with this project - thanks

Del

 

[Smitty]

Take a look at the Find method in the VBA helpfile. It will help you identify which record is being updated and you can deduct the inventory count.

Feel free to post whatever code you have so far and someone can help you with it.