Finalising a Database/Preventing more additions

[Himy]

OK so I'm new to a lot of this but here goes..

I have a database - it has over 1200 records with 35 fields in each record. Once I have finished adding in all the data - I want to be able to use the form I've created to enter the data, as a lookup form, for people to have in front of them - by simply typing in the model code (primary key) it will recall all the fields in that record.
At the moment, when I type a new model code over an existing record, it doesn't take me to a new record, it simply overwrites the old model code. I want to be able to make the form recall information by typing in the model code, and if any field is typed into or adjusted - it will bring up a message saying something to the effect of "Are you sure you want to change the data for BLAH BLAH BLAH." I thought this would be as simple as pressing a compile button or something but it doesn't appear that way!!

Hope you can help,

Regards,

Himy

 

[GTrice]

Try using a Form / Subform combo. On the parent have a single unbound combo box for the user to select from. Have the data in the subform linked to the value in the unbound combo. The source for the subform should be limited to the value in the unbound combo.

Hint: In query criteria - "=[Forms]![form name]![unbound combo name]" Also, be sure to set the Parent/Child Property settings on the subform.

Cheers