open a record,

trixxnixon

i have a form bound to a table, with a primary key(autonumber) "recordno"
on this form, i have a dlookup that looks up a specific "recordno".

how can i get this form to open up the record corresponding to the value that the dlookup outputs.

puppydogbuddy

in the code below txtrecordno represents the textbox on the form that you are using for the recordno you want to display via the DLookup, although your use of the DLookup to determine what record you want to display does not make sense to me. Replace any illustrative names I used for the objects in your application with their actual names.

Expand|Select|Wrap|Line Numbers

 
Private Sub txtrecordno_AfterUpdate()

If DCount("[recordno]", "YourTable", "[recordno] = " & Me.txtrecordno) > 0 Then

        DoCmd.OpenForm Me, , , "[recordno] = " & Me.txtrecordno

Else

        MsgBox "The recordno you entered does not exist."

        Me.txtrecordno.SetFocus

End If

End Sub

open a record,

re: open a record,

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about