darth sidious
Registered User.
- Local time
- Today, 02:43
- Joined
- Feb 28, 2013
- Messages
- 86
Hi
I've attached the database I'm working on. The problem I have relates to the DLookUp I have on the form frmFindSeats. I have a query for the Combo box 'available seats' which finds all the free seats for you to select one from. The normal price field should display the price for this seat from the 'Seat' table.
I believe I have correctly used the dlookup: =DLookUp("[Price]","Seat","[SeatNumber]=[cboAvailableSeats]")
However, no price is displayed in the Normal price text box. Please help, this has been holding me up for too long!
Kind Regards
Darth
I've attached the database I'm working on. The problem I have relates to the DLookUp I have on the form frmFindSeats. I have a query for the Combo box 'available seats' which finds all the free seats for you to select one from. The normal price field should display the price for this seat from the 'Seat' table.
I believe I have correctly used the dlookup: =DLookUp("[Price]","Seat","[SeatNumber]=[cboAvailableSeats]")
However, no price is displayed in the Normal price text box. Please help, this has been holding me up for too long!
Kind Regards
Darth