Search results

  1. J

    Parameter query in VBA

    Hi Everyone, I have a customer forms with a subform containing details of videos being hired. Each time the user click on the video combo box and select a movie, I want it to run a query in the background to see if the video has been previously hired by this customer and if so to pop up a...
  2. J

    Limit display of duplicate

    Hi Guys, I have a Table that stored movies. As there are multiple copies of the same movies each with its own unique Id such as 0001-1 and 0001-2 for copy number two. However as both have the same movies title, how could I limit the query to display only one entry for each movie. Any help...
  3. J

    Set field value on forms

    I have a video rental form/subform. Video products have a field called status. Everytime someone hires a video I want it to be automatically updated to "Out" I have try to write a code so that when a video is selected in the subform the underlying field 'status' in the product table will be...
Back
Top Bottom