J
Jesse
I am new to Access and don't know much about VBA either, so this is driving
me crazy! I have a form with two combo boxes. Each combo box gets their
list of choices from lookup tables that are referenced to a main table. The
selections the user makes reference a query on the main table. I then want
the user to click a button and fill in several text boxes with data for that
record from the main table. I can't (don't know how) to get the text boxes
to reference the query so that they fill in when the user clicks the button.
I also want to create a subform with data related to the main table (a child
table) that also fills in the selected records after the user clicks the same
button.
First of all, is this a correct methodology, or am I going about this the
long way? Second, I need an example of where and how to put the code to
reference the query to get the data to fill in (I know it should go in the
OnClick event for the button but I'm stuck after that).
Thanks,
Jesse
me crazy! I have a form with two combo boxes. Each combo box gets their
list of choices from lookup tables that are referenced to a main table. The
selections the user makes reference a query on the main table. I then want
the user to click a button and fill in several text boxes with data for that
record from the main table. I can't (don't know how) to get the text boxes
to reference the query so that they fill in when the user clicks the button.
I also want to create a subform with data related to the main table (a child
table) that also fills in the selected records after the user clicks the same
button.
First of all, is this a correct methodology, or am I going about this the
long way? Second, I need an example of where and how to put the code to
reference the query to get the data to fill in (I know it should go in the
OnClick event for the button but I'm stuck after that).
Thanks,
Jesse