i want on the sales rep form i have a list box i want to have the rep click on the order in the list box and it goes to that order is there a way i can do that.
Sure. Just add a list box with an OnClick event to open that order. I've covered this in lots of lessons.
jannette jonesOP
@Reply 6 years ago
Private Sub TechprojList_DblClick(Cancel As Integer)
If IsNull(TechprojList) Then Exit Sub
DoCmd.OpenForm "TrackerProjectF", , , "ProjectID=" & TechprojList
Me.Refresh
End Sub
i did this but not working
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.