Hi folks, hope someone can help me with this one because it's got me puzzled (no change there then).
I have a form with a subform. The main form has two cascading comboboxes on it which work fine.
I have created 3 textboxes bound to a table and the corresponding fields.
What I would like to happen is when I make my selection from the second combobox, the textboxes update automatically.
In the AfterUpdate event for the second combobox I requeried the subform which works great, I have tried requerying the main form and individual controls to no luck.
The Recordsource for the mainform is set to the table from which the fields bound to the three textboxes are.
I would like also to be able to amend the details in the three text boxes and save the record accordingly.
Can anyone help please?
BTW - this is the LAST database I am ever creating so please help me go out with a bang!
Regards, Lol
I have a form with a subform. The main form has two cascading comboboxes on it which work fine.
I have created 3 textboxes bound to a table and the corresponding fields.
What I would like to happen is when I make my selection from the second combobox, the textboxes update automatically.
In the AfterUpdate event for the second combobox I requeried the subform which works great, I have tried requerying the main form and individual controls to no luck.
The Recordsource for the mainform is set to the table from which the fields bound to the three textboxes are.
I would like also to be able to amend the details in the three text boxes and save the record accordingly.
Can anyone help please?
BTW - this is the LAST database I am ever creating so please help me go out with a bang!
Regards, Lol