D
Dave
I have two tables and I am creating a 3rd table based on
the values selected from a LIST BOX.
On form1, the record source is table1 which displays
field1 in single form mode. (ONE)
I also have a list box on form1 that lists the data in
table2 which displays field2. (MANY)
I would like the user to double click on field2 (in the
list box) and create 1 record in table3 that stores field1
and field2.
I have a 3rd form that displays table3) so once I get it
linked and requery, the 3rd form will update with the
newly added record.
Any hints on what command and syntax to use on the double
click event when the user double clicks the row on the
list box? I hope it would be easy to obtain the value of
the list box and should be easy to call the value on the
main form, just need to put them together and write it to
a table.
Thank you for your help, it seems the more I learn, the
more I want to do hence the more questions I have.
the values selected from a LIST BOX.
On form1, the record source is table1 which displays
field1 in single form mode. (ONE)
I also have a list box on form1 that lists the data in
table2 which displays field2. (MANY)
I would like the user to double click on field2 (in the
list box) and create 1 record in table3 that stores field1
and field2.
I have a 3rd form that displays table3) so once I get it
linked and requery, the 3rd form will update with the
newly added record.
Any hints on what command and syntax to use on the double
click event when the user double clicks the row on the
list box? I hope it would be easy to obtain the value of
the list box and should be easy to call the value on the
main form, just need to put them together and write it to
a table.
Thank you for your help, it seems the more I learn, the
more I want to do hence the more questions I have.