I am using VISUAL BASIC 6 as the front end application linking through to a Microsoft Access database.
I was wodnering how i would lookup information stored in a table in access and display the results on the fly.
i have a data control called: navRentals
linking to: Database.mdb
I then have a combobox called: cboRentalTitle
this is populated with rentals from (Database.mdb) tblRentals.RentalTitle by using the following code (On form load)
Loop Until navRentals.Recordset.EOF
what i am after is a way to LOOKUP the 'AgeCert' value and the 'Price' from tblRentals based upon the value selected in the combo box (this is needing to be updated if a new rental is selected in the combo box - i think its combo.change property?)
I have a command button that adds the selected film title to a list box. (lstRentedItems).
I have the ability to add and remove rentals using 2 buttons - this also deducts the price.