Automatic Load

[malamogan]

I have a problem.
I have 2 tables. One table is a Master Table and another one is a Transaction table. What I need to know is, when I choose the key field in transaction table, I want all the information for this key field automatically displayed in the transaction table (or form) and I want to input some infornation for the rest of the field in the transaction table. Please, anybody have any sugestion???

 

[aexley]

Being a beginner at VBA coding I have used a macro that uses SetValue for all the fields in the destination form that I want from the source form and is activated when the destination form loads. If anyone else knows a less involved way I'd like to know but this has worked fine for me.

Hope it helps.