Prevent Duplicates Upon Selection from Combo Box

[xx_phenom_xx]

hi
I have a combo box in ms access 2007 for movie titles. What i want to do it is when a customer tries to select a movie, they cannot select that same movie again if they want to borrow more movies. I want them to show an error message when


they try to select a "borrowed movie". How can I do this?
Thanks

[CJ_London]

you need to provide more information - the structure of the relevant tables and some sample data plus the rowsource of your combobox and details of the context in which it is being used - in a single form, a continuous form, on the header section or the detail section.

Also please do not double post, select a forum section and if you don't get a response within a couple of days, try a different section, but advise that you have tried a different section and provide a link.

Other posts here
https://www.accessforums.net/forms/c...elp-52041.html
https://www.accessforums.net/access/...lpp-52039.html

Please read this link

http://www.excelguru.ca/content.php?184

[June7]

Duplicate threads deleted.

If you want to provide db for analysis, follow instructions at bottom of my post.

Instead of the error message approach, it would be better to structure the combobox to not even include movies in the list that user already has. This does require a rather complex query structure for the combobox RowSource.

You might take a look at the MS Lending Library database template.

[xx_phenom_xx]

hi, sorry about the duplicate threads

my row source for the combobox is SELECT [Movie Table].[Movie Code], [Movie Table].Title, [Movie Table].[Rental Price]FROM [Movie Table]
ORDER BY [Movie Table].[Title];


It is being used in a single form

This is structure of my movie rentals table

[xx_phenom_xx]

Hi june 7

Yes I would consider this in my database
If you would provide some steps , that would be great.

Thanks

[June7]

The technique has been discussed in numerous threads, however, finding them again is not easy but here are a couple.
https://www.accessforums.net/forms/p...orm-20177.html
Start with post 11 in https://www.accessforums.net/queries...ria-45796.html

Have you looked at the Lending Library db? I expect it has an example.

Providing guidance would be easier if I knew your db structure. Want to provide it as already suggested?