Really Need Help!

[aaron23jordan]

Hi, I'm currently constructing a database for a Video/DVD rental shop.
It's simple, I have got it all constructed however this is my problem -

I have a table with all of my videos in. In this table i have the videos and a tick box to say if they have been hired. (Tick for hired, no tick for not hired).

I also have a form that allows me to hire out videos. Everything works fine, my database calculates the fines all good but...I want to run an update query in the form that will update a video from not hired (no tick) to hired (tick). I have created an update query and have made it update to - Yes - but the problem is that it updates that tick box for every video in my table to yes, not the individual video that i am renting out. I want to be able to run a query that will update the tick box for a single video in my table not every video in my table.

Can anyone help?

 

[Mikk]

Ok sounds like you need to add a criteria

On the query screen add the field "DVD title" or whatever you have called it.

Add that to the query then under that coll in Criteria put [Name of DVD]. When the query is run a pop up box should come up to ask you for the name of the dvd and hopefully only that record will be ticked when the name is entered!

Hope this helps!

Mikk