ikalemi
07-03-2017, 07:51 AM
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:
Project (CC1)
Funding Agency
Grant Name (CC3)
Contract Number
Start Date
End Date
Status
Category (Account)
Amount
Voucher Frequency
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
8310: Travel
$ 5,445.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7240 : salary
$ 12,000.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7545: Client Transition Fund
$ 552.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7580: Professional services
$ 2,333.00
Month
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7240 : salary
$ 5,000.00
Quarter
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7240 : salary
$ 25,000.00
Quarter
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7582: Sub-Contractors
$ 45,454.00
Quarter
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
Project (CC1)
Funding Agency
Grant Name (CC3)
Contract Number
Start Date
End Date
Status
Category (Account)
Amount
Voucher Frequency
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
8310: Travel
$ 5,445.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7240 : salary
$ 12,000.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7545: Client Transition Fund
$ 552.00
Month
1000
DYCD
DYCD Kids
4441
1/1/2017
6/30/2017
Not Reg
7580: Professional services
$ 2,333.00
Month
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7240 : salary
$ 5,000.00
Quarter
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7240 : salary
$ 25,000.00
Quarter
1300
HRA
HRA !!
2243
7/1/2016
6/30/2017
Final
7582: Sub-Contractors
$ 45,454.00
Quarter
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