Recent content by RedTrac

I tried out the following code and after lots of trying out other ways, it is still not working :( When I click on the search button all the records disapear. --- Private Sub btnsearch_Click() SQL = "SELECT Rooms.Room_id, Rooms.Sleeps, Rooms.Type, Rooms.Phone Number, Rooms.Price...

Thank you so much for your help. This should'nt be a problem as I dont have too many records.

Im creating a search form for my database and written the following SQL for it, SELECT Rooms.Room_id, Rooms.Sleeps, Rooms.Type, Rooms.Phone Number, Rooms.Price, Bookings.Date FROM Rooms, Bookings WHERE Date="txtdate", Type="cbtype"; I have two fields one being "txtdate" and one being a combo...

Iv built an expression in my bookings form to try and calulate the toal cost of a booking using the 'price' field on the Rooms table and 'Nights' on the bookings form but its not working. Can anyone tell me whats wrong here? =Bookings!Nights*Rooms!Price Thanks, RT