Quote Originally Posted by alansidman View Post
So what? Its only a number that is used for tracking. It equates to a title and is used for maintaining a unique value for the record. It should have no other bearing. This is a relational database and not a spreadsheet.
I didnt think of it like that.


Looked at your code for the button. Reverse the order of the docmds. You want to open the form first and then add a new record.
.
OK will fix that .. thanks

Your third item. You have named your form "Search Movies" but in your query you are directing the criteria to look at the form "SearchForm" which does not exist.
OK will fix that too

I don't understand the need for a form to edit the results as you can edit the results directly in the query data sheet.
good point and again something i didnt think of.

If you want a duplicates query, use the query wizard to create a duplicates query.
ok will have a look at that.

[quote]I also don't understand the need for a disk nr. in your table and search.[multiple movies on them and the disks themselves are all numbered/quote]
the disk number is because i have a large number of disks with

BTW, you should change your field names to not include # sign. Access doesn't like special characters in field names. Here is link to reserved names and characters

http://support.microsoft.com/kb/286335
ok will fix that also ... thanks


appreciate your responses and I will post again with the results of your suggestions and answers.

thanks heaps for that