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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PmF
  • Order by date
  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...

Part and Inventory Search

Back
Top