We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
(SELECT TOP 1 [Payment Receipts].[Receipt Number] FROM [Payment Receipts] WHERE [Renter Space Assignments].[Space Number] = Forms![Rental Property Management]![Payment Receipts_Space Number] ORDER BY [Payment Receipts].[Receipt Number] DESC) Private Sub Payment_Receipts_Space_Number_AfterUpdate() Dim RecVar As Variant Dim MatchVar As Variant Dim TableVar As Variant MatchVar = Me![Payment Receipts_Space Number] TableVar = [Renter Space Assignments].[Space Number] RecVar = DLookup("[Receipt Number]", "Payment Receipts", "'" & TableVar & " = " & "'" & MatchVar & "'") Me![Receipt Number].SetFocus DoCmd.FindRecord (RecVar), acAnywhere, False, acSearchAll, False, acCurrent, True End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Access Database 2007 - automating reports being sent by email||2||58|
|Converting Access 2016 from 32-bit to 64-bit||8||62|
|Cant delete records in query||8||50|
|SUBFORM on ACCESS 2013||8||36|
Join the community of 500,000 technology professionals and ask your questions.