Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PmF

  1. PmF

    Selecting price from table using data in another table

    I have messed up somewhere. I renamed the boxes on the form taking out the B because I realised I can call them the same name as fields on a table. Now I have #Error in the calculated control and when I select anything from the list boxes I get the message: the expression After Update you...
  2. PmF

    Checkbox to update value in calculated control?

    I have a checkbox called Parking on a form called frm_Booking and when checked it needs to update the AmountDue field on the same form by adding £10 to the value. How do I do this?
  3. PmF

    Selecting price from table using data in another table

    Sorted it, the formula works fine but when I enter it Access says it can't find the field name Forms??? as soon as I go back to the form and test it, it works fine, thanks again
  4. PmF

    Selecting price from table using data in another table

    I can get the field to work for one specified criteria but not anymore. Below is what I have for the control BPrice as the value =DLookUp("[Price]","tbl_Prices","[Season]=Forms![frm_Booking]![BSeason]" And "[Service]=Forms![frm_Booking]![BService]") on...
  5. PmF

    Selecting price from table using data in another table

    I have a table that stores booking info for a hotel, dates etc. It also lets you specify the season (winter, summer, christmas, new year) the number of nights (1 to 7) the room type (deluxe, single, luxury) and service (B&B or Dinner, B&B) I then have a table tbl_Prices which stores a price for...
See more

Part and Inventory Search

Back
Top