Recent content by Apricot

Doing this in VBA is much longer than I originally envisaged. As I promised to get this done by lunch on Monday I have decided to separate the code from the data by moving the database to SQL Server and writing a custom front end in C#. Thank you for your assistance.

Done, now what?

It certainly would be easier if the record source was a sorted query, but in my case the data source is a table which contains randomly entered data. The form sorts the data by two number fields, first by Dock then by Point, both acceding.

Apologies for the delay in replying. The table has 16 fields in total. It is sorted by two number fields: Dock & Point.

The field is a standard number field, I would have used a autonumber field , but the field has duplicate values.

Correct me if I am wrong, but as far as I know Dmax returns the maximum for the entire field, not only the previous record.

You are correct that is basically what I am trying to accomplish, but I am not sure how to accomplish it. I know how to set a default value, but not how to create a default value based on the previous record. Any help would be appreciated.

The form has been created in such as way as to limit the ways a new record can be created, I am not the original author, I am just trying to add a small modification. I have found out i can use the keydown event to start the event, for for the rest I need help.

Hi everyone. I am trying to write some vba code to auto fill a cell's value based on the value of the cell in the previous record (In a datasheet form) i.e. if the value in record one was '1' and the down-arrow key was pressed then the value '2' should be entered into the new\next record I...