patrickglass
Engineering Student
- Local time
- Today, 12:17
- Joined
- May 10, 2006
- Messages
- 10
Hello, i have an equipment table and an equipmentHours table. linked by an id on the two. basically i have an hour reading on the machines that gets entered every once and a while. no set times or dates. i have an equipment for where you can view the current equipment data. i was now would like to be able to just display the latest hour reading and the date it was taken, i dont really want to use a subform for just one record but i dont know what else i can do.
two textboxes txtEquipmentHours and txtHoursDate
i would like both of the populated with teh latest record with reference to the EquipmentID
I know how to use dlookup for returnnin a specific record but it cant sort so i dont know how i could have it link to the correct record. I hope someone gets what im trying to acheive. Thanks for the time. Patrick Glass
two textboxes txtEquipmentHours and txtHoursDate
i would like both of the populated with teh latest record with reference to the EquipmentID
I know how to use dlookup for returnnin a specific record but it cant sort so i dont know how i could have it link to the correct record. I hope someone gets what im trying to acheive. Thanks for the time. Patrick Glass