I am working on a project where I have a GUI built with Access forms and a few tables to hold information.
I am having trouble populating a textbox on a form within my project. I have attached the Access db and here is a description of what I am expecting to happen in the project.
1. User opens the db and the "CurrentAnalytics" form open (dev stage - not yet functional)
2. They select from the two comboboxs and press submit which brings them to the "AnalyticsMenu" form.
3. User selects High Claims from the "AnalyticsMenu" and this is where the problem occurs.
Problem 1:
I am trying to have the form populate Textbox 1 from tblAnalytics (given certain conditions: GN = GRPNM and GT = GTSN in the table, which are selections made on the first form). I am attempting to set these as global vars in the "CurrentAnalytics" form and use them within all the forms.
Currently, the textbox is not populating on open. I also need to populate textbox 2 from the same table, but did not bother trying to code that until i get it working for one instance.
Problem2:
OnSubmit I need to accomplish the following:
Reload the form with the content of textbox 3 both stored in an appropriate cell in the db and show the content of that cell in textbox 2
Thanks for the help,
Mike
I am having trouble populating a textbox on a form within my project. I have attached the Access db and here is a description of what I am expecting to happen in the project.
1. User opens the db and the "CurrentAnalytics" form open (dev stage - not yet functional)
2. They select from the two comboboxs and press submit which brings them to the "AnalyticsMenu" form.
3. User selects High Claims from the "AnalyticsMenu" and this is where the problem occurs.
Problem 1:
I am trying to have the form populate Textbox 1 from tblAnalytics (given certain conditions: GN = GRPNM and GT = GTSN in the table, which are selections made on the first form). I am attempting to set these as global vars in the "CurrentAnalytics" form and use them within all the forms.
Currently, the textbox is not populating on open. I also need to populate textbox 2 from the same table, but did not bother trying to code that until i get it working for one instance.
Problem2:
OnSubmit I need to accomplish the following:
Reload the form with the content of textbox 3 both stored in an appropriate cell in the db and show the content of that cell in textbox 2
Thanks for the help,
Mike
