Auto Populate form

[fpsmi]

I have a database i need to create a form that will auto populate based on an entered field.

I have two tables:


- tblMailing
- tblSurvey

tblMailing has the customer information with a unique id field "FI_Code". This database is imported monthly.

tblSurvey has about 25 survey fields that will link to the tblMailing database by an "FI_Code".

I need to create a form where the user types in the "FI_Code" and it will auto populate some fields from the "tblMailing" table, and also show the BLANK survey fields from "tblSurvey"

Need to be able to fill out the survey based on the "FI_Code" and have it saved back to "tblSurvey"

Any help is greatly appreciated.

Thanks

[apr pillai]

I have replied with a solution to a similar thread earlier, here is the link:

https://www.accessforums.net/forms/s...elp-17127.html