Can someone help me pls. I’m developing an application for my small travels and tours agency that will handle the personal information and reservation requests of customers. I want a situation where when I click the view reservations button from within the customer page, the “Reservation form” will load and displayed only the results matching the customer ID as shown on the “View Customer” form customer ID textbox.
Below is the form load event procedure that I have which is not working:
Private Sub Form_Load()
Dim strSQL As String
strSQL = “SELECT * FROM reservation WHERE cusIdNum = CusIDval”
res_Edith_btn.Enabled = False
End Sub
“reservation” is the name of the table to hold reservation information of various customers.
“cusIdNum” is the name of the customer identifier ID field on the reservation table as picked from the customer ID textbox when adding a reservation.
“CusIDval’ is public declaration value of the customer ID textbox on the customer view page.
