I desire to pull certain fields from a record in one table into a different table using a drop-down box in form view. How is that accomplished? I trully need step by step instructions. I have read programing books on how to do it, but it never works. I have never met anyone who knows how to do it. You can be the first.
Thank you! My God bless you for your efforts!!!!
I'm not sure exactly what you are looking for. However if you have a dropdown box (cboCust) with 5 field from tblCustomer as follows:
SELECT custID, custName, custADR1, custADR2, custADR3
FROM tblCustomer;
Then you can refer to those fields as follows:
Me.cboCust - will refer to the custID field assuming its the bound field
Me.cboCust.Column(2) - will refer to the custName field
and so on.
However, inserting duplicate information from one table to another is not encourages in databases as it causes problems. I suggest you check out this tutorial first.
Database Normalization and Table structures