Userforms

[brooklyn86]

Hello, I am trying to create a userform for a database that repeats information in rows as I enter other information like Category and Amount. As an example, see below table:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD]Project (CC1)[/TD]
[TD]Funding Agency[/TD]
[TD]Grant Name (CC3)[/TD]
[TD]Contract Number[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Status[/TD]
[TD]Category (Account)[/TD]
[TD]Amount[/TD]
[TD]Voucher Frequency[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]DYCD[/TD]
[TD]DYCD Kids[/TD]
[TD]4441[/TD]
[TD]1/1/2017[/TD]
[TD]6/30/2017[/TD]
[TD]Not Reg[/TD]
[TD]8310: Travel[/TD]
[TD]$ 5,445.00[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]DYCD[/TD]
[TD]DYCD Kids[/TD]
[TD]4441[/TD]
[TD]1/1/2017[/TD]
[TD]6/30/2017[/TD]
[TD]Not Reg[/TD]
[TD]7240 : salary[/TD]
[TD]$ 12,000.00[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]DYCD[/TD]
[TD]DYCD Kids[/TD]
[TD]4441[/TD]
[TD]1/1/2017[/TD]
[TD]6/30/2017[/TD]
[TD]Not Reg[/TD]
[TD]7545: Client Transition Fund[/TD]
[TD]$ 552.00[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]DYCD[/TD]
[TD]DYCD Kids[/TD]
[TD]4441[/TD]
[TD]1/1/2017[/TD]
[TD]6/30/2017[/TD]
[TD]Not Reg[/TD]
[TD]7580: Professional services[/TD]
[TD]$ 2,333.00[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD]HRA[/TD]
[TD]HRA !![/TD]
[TD]2243[/TD]
[TD]7/1/2016[/TD]
[TD]6/30/2017[/TD]
[TD]Final[/TD]
[TD]7240 : salary[/TD]
[TD]$ 5,000.00[/TD]
[TD]Quarter[/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD]HRA[/TD]
[TD]HRA !![/TD]
[TD]2243[/TD]
[TD]7/1/2016[/TD]
[TD]6/30/2017[/TD]
[TD]Final[/TD]
[TD]7240 : salary[/TD]
[TD]$ 25,000.00[/TD]
[TD]Quarter[/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD]HRA[/TD]
[TD]HRA !![/TD]
[TD]2243[/TD]
[TD]7/1/2016[/TD]
[TD]6/30/2017[/TD]
[TD]Final[/TD]
[TD]7582: Sub-Contractors[/TD]
[TD]$ 45,454.00[/TD]
[TD]Quarter
[/TD]
[/TR]
</tbody>[/TABLE]


Project would be a combo box with a dropdown list with all the project.
Grant name would be a textbox.
Start date would be a text box.
Same with End Date.
Status would be a combo box with a dropdown list.
Category is a combobox with dropdown list.
Amount textbox.
Voucher frequency is combobox with a dropdown list.

I apologize in advance if I am not clear in my explanation.

thank you

 

[My Aswer Is This]

In your example it appears as if all the information in all the columns except for two will always be the same.
So why do you need a Userform and comboboxes?

Just enter the values you want into the columns where you plan to enter the Category and Amount and we could have a script enter all the other data.

 

[brooklyn86]

Thank you for looking this over, and sorry for not being clear. I am trying to create a database for the agency funding. The agency has 11 different departments(projects, lets say project A to K) with different funding sources(grant & contract number), and different funding dates(Start & End date). Now, each funding source has its own budget broken down in different amounts for each category likes salary, supplies ect. The time for claiming the funds is also different for each funding source. To summarize, each funding source will have one or multiple departments, one contract number, one start and end date, multiple categories and amounts , one one vouching period. I hope this makes sense.

I want to create a userform so each department inputs the data, and the I can pivot the database to extract only the information needed.

thank you again for looking this over.