Search results

Thanks for the directing me to the article. Much appreciated and hope to make some progress soon.

Hi Rich, The CustId is in the main form while the ProductId in the subform. I intend to place the code in the After Update properties of the ProductId combo box in subform. The relationship between the tables are: One customer may order one or many rentals and each rentals must have one or...

Thanks to Rich and Hicks for prompt reply. However I am still stuck. Forget to mention that the required query is based on three link tables and two criteria one from customer Id on main form and product Id on subform. Is it still possible and how can I write the code in VBA. Can someone...

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...

It worked! Thanks a million Jon for your prompt reply. Much appreciated as I almost give up after a week of trying. :)

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...

Update queries Thanks a million to you both, Jack and Pat. Much appreciated. I have figured out your simple suggestion Jack and it worked fine now. However in trying to execute Pat idea, I am completly lost as the queries update the Rented To fields on Product tables for all customers instead...

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...