LeeHutchins
New member
- Local time
- Today, 08:09
- Joined
- Nov 3, 2020
- Messages
- 13
I have a edit record button on my Landing Page that should take me to another form "ContractDetail" so it can be edited, however it will only take me to the first record it is not finding the record I have selected
I have a command box to test the me.ID and this is returning the correct ID value but yet it still isnt finding the correct record in the ContractDetail form.
thanks for any help in advance
Code:
Dim ContractID As String
ContractID = Me.ID
DoCmd.Close acForm, "Landing Page"
DoCmd.OpenForm "ContractDetail"
DoCmd.FindRecord (ContractID)
I have a command box to test the me.ID and this is returning the correct ID value but yet it still isnt finding the correct record in the ContractDetail form.
thanks for any help in advance