Keep it simple stupid data from form to table

[Cosmo]

Hello all,

This is what I need to do:

One database
two tables (one master one lookup)
one form

primary table will recieve 8 pieces of data from a look up table
The lookup table can change in future but the master must never change after data is entered.

Need to scroll through list box and find correct record in look up table then upon a event push all eight pieces of data to the master for a historical snapshot (never to change even if look up table does)

What is the best "Schema" for this challenge?

More specifically, how to I get the 7 remaining peices of data associated with the the list box selection and assign them to the correct position in the master?

This is a one shot trigger deal and not relational between the tables

This is a VBA app I believe and not well suited to expressions and or macros but I could be very wrong???

Yes, I have done my homework but want to hear ideas before showing and debugging my code.

 

[pbaldy]

I'd probably use the after update event of the listbox to copy the various items from the chosen item in the listbox to bound textboxes.

 

[Cosmo]

10-4 Thats what I did and it works great

I acquired the column data from a checkbox and pumped it into individual fields of the master table.


Thanks

 

[pbaldy]

No problem, and welcome to the site by the way.