I'm designing a database in MS Access 2013 custom web app to track projects. I need to autopopulate textboxes based on a drop down box.
The drop down contains month names (Jan, Feb, March etc.), and then there are textboxes with the names Jan, Feb, March etc. Now when the user chooses say feb from the dropdown box the Feb textbox needs to get filled with a calculated value, also the next 6 months also need to updated with the calculated value. So if a person chooses March from the dropdown menu, March-November all textboxes should auto populate with the calculated value.
I know I need to use After Update macro but what Macro should I write.
This is how my table is built
Id (Primary Key autonumber)
Savings (numbers) [value to be input in the textbox]
Month (lookup with values entered)
Jan (number)
Feb (number)
March (number)
This is what I have tried so far: I created a data macro that basically stores the value of the drop box field selected and I use ReturnVar to return the value in the AfterUpdate Macro and SetProperty. But, how do I make it populate to the fields that I want.
I'm not very experienced with Access yet, and have limited experience with both Macros and VB, so I appreciate any suggestions!
The drop down contains month names (Jan, Feb, March etc.), and then there are textboxes with the names Jan, Feb, March etc. Now when the user chooses say feb from the dropdown box the Feb textbox needs to get filled with a calculated value, also the next 6 months also need to updated with the calculated value. So if a person chooses March from the dropdown menu, March-November all textboxes should auto populate with the calculated value.
I know I need to use After Update macro but what Macro should I write.
This is how my table is built
Id (Primary Key autonumber)
Savings (numbers) [value to be input in the textbox]
Month (lookup with values entered)
Jan (number)
Feb (number)
March (number)
This is what I have tried so far: I created a data macro that basically stores the value of the drop box field selected and I use ReturnVar to return the value in the AfterUpdate Macro and SetProperty. But, how do I make it populate to the fields that I want.
I'm not very experienced with Access yet, and have limited experience with both Macros and VB, so I appreciate any suggestions!
