Recent content by Hastingwood

Recordsource is a query that filters readings to only show the ones for the selected meter. Sorted to have the latest one at the bottom. So the main form shows the selected meter' information, and a subform in a datasheet view shows all readings for that meter. New readings are added into this...

The form is in a datasheet, its just the record above the new one being entered...the last one in the query behind the form? Its Access 2003 btw

Hi All I would really appreciate some help, am rather lost atm.:banghead: I am creating a small database that will keep track of some utilities meters and the readings taken from them. When entering a new reading I would like the system to check the reading against the previous one and if...