/TypeScript/Access - Open form non data entry mode

Access - Open form non data entry mode

Private Sub openRecBtn_Click()
    Dim numID As Long

    numID = InputBox("Please enter the ID : ")

    If DCount("*", "yourTable", "numberID = " & numID) <> 0 Then
        DoCmd.OpenForm "tmpFrmName", WhereCondition:="numberID = " & numID
    Else
        MsgBox "The numberID : " & numID & " does not exist, please try again !"
    End If
End Sub

Source: stackoverflow.com

Similar codes

1 vote115 views2 answers
Ffmpeg batch convert ts to mp4 files in a folder
TypeScript
1 vote99 views1 answer
Google sheets remove characters from string
TypeScript
0 vote99 views1 answer
Mat stepper dont clickable
TypeScript
1 vote110 views1 answer
How to show contents of a file in linux
TypeScript
0 vote93 views1 answer
Angular TS2377
TypeScript
3 votes115 views1 answer
Regex replace certain string
TypeScript
1 vote101 views3 answers
Roperty 'form' has no initializer and is not definitely assigned in the constructor.
TypeScript
0 vote105 views1 answer
Google sheets countif two conditions
TypeScript
0 vote106 views1 answer
Outputs i angular
TypeScript
0 vote99 views1 answer
How to take multiple int inputs in the same line in C++
TypeScript