Access ADP Project Form

This is an ongoing poject, for now I have a SQL Server database, I need an Access front end .adp file with one form (the form is already designed). The form has many fields, some of them (14 fields) already exist in 4 tables in the database and the rest of the fields are new and not existing in the database. The objective is to open the form, once the user edits a specific field (spec #) the 14 fields should automatically be filled out with the data that exist in the database, the user then would continue filling out the other fields, the whole form should then be written to a new table as a new record. User should be able to navigate, modify or add new records. ## Deliverables Complete ownership and distribution copyrights to all work purchased. ## Platform Windows 2000 Pro and SQL Server 2000