Hi,

I just have another question. At this time i have a command button an my form to add a new record, or to look at the last entry. (the record navigator property has been set to 'no').

I would like to change the 'data entry' property of the form to yes, but than only new records can be added, a previous one can't be looked up.

Now what I would like to know is: is it possible to create a subform on which I would be able to look at the last complete entry? So if I add some new records, the subform should always display the last complete entry. The subform should be updated every time I press the command button 'new record' or if the form is opened of course. Can this be done? If yes, how do I have to do this?

thanks

Vince, search Access help for the following three form properties: AllowEdits, AllowAdditions, AllowDeletions.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division