Populating fields using forms (1 Viewer)

[daverskully]

am looking to populate fields of one form based on another table with about 100 records.


Information
Table Name: 1) StaticInfo
2) Data

Form Name: EntryForm (Based on the Data table)

I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.

Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.

So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?

Also, could someone provide a method as to how I would go about populating these fields from table to form

What about having a sub-form of the StaticInfo at the top of the EntryForm, if the staticinfo was obtained for the department by way of the sub-form, would this subform information be able to populate the Entryform so that the new record, created by EntryForm and stored in the table Data, also contains these StaticInformation fields. Just brainstorming here. Any solution would be great.

Thanks in advance.

 

[llkhoutx]

The Statinfo should be the record source for the form; use a combo box (in you form header) to select the filter the record source.