LinkBack URL
About LinkBacks
vampyr07au 
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.As you suggested I have used the ID field to create the movie number entry however it is defaulting to the number 2 which is the first entry in the field column of the table instead of defaulting to the next new entry number.
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.second - on the add new movie form itself - you need to click the add new button once to clear the fields to be able to create a new entry and then click it again after entering the details so that it then creates the new entry. If you enter new data and then click the add new button it clears the fields and then creates a new entry.
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.
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.
If you want a duplicates query, use the query wizard to create a duplicates query.
I also don't understand the need for a disk nr. in your table and search. 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
Alan
Alan
Register To Reply
Originally Posted by alansidman
Bookmarks