Results 1 to 1 of 1
Thread: combo boxes & userForms
2001-06-10, 00:41 #1
- Join Date
- Mar 2001
- Dallas, Texas, USA
- Thanked 1 Time in 1 Post
combo boxes & userForms
I have encountered a problem as I am attempting to populate a database through UserForm entries. As long as it was just text boxes, it was simple. But now, it gets tricky...
The Userform requires that an expense acct be chosen from a combobox and then an amount entered into a text box. The user can enter up to six accts and six amts.
The db is setup with dates down the "A" column and the expense accts entered across the top as column headers (six times).
I need help with the code that will send the amount(s) to the correct cell in the db when the [Save] btn is clicked. I know this is far from clear so I have attached a much smaller version of my problem as an example.