/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

0 vote137 views1 answer
HIGHER-ORDER FUNCTIONS with two parameters
TypeScript
0 vote103 views0 answer
TypeScript
0 vote158 views1 answer
Typescript document.queryselector type
TypeScript
0 vote169 views1 answer
The derived ungapped alignments are calleed
TypeScript
0 vote175 views1 answer
Inteface method extension angular
TypeScript
5 votes144 views1 answer
Angular array filter typescript
TypeScript
0 vote154 views1 answer
Meta tag utf-8 means kya hota hai
TypeScript
0 vote135 views1 answer
Is missing in props validation typescript
TypeScript
0 vote138 views1 answer
Mysql workbench an apparmor policy prevents this sender
TypeScript
0 vote112 views1 answer
Unable to determine application id: com.android.tools.idea.run.ApkProvisionException: No outputs for the main artifact of variant: debug
TypeScript