I have a database that I filter then I use the end + down keys to select the
filtered records. I require that the the last name must be entered in the
record so that the end -down keys will go to the last record. If someone
enters a record without putting in the last name then the end - down doesn't
select all of the filtered records.
Is there a way to force a last name being entered before the record
is saved? I use ActiveSheet.ShowDataForm for data entry

oldjay