You can't go to the specified record.

[GarveyUSMC]

I am messing around with access 2007 now for about 2 weeks. I think it is going to be pretty awesom but I am hitting troubles every step of the way so I decided to finally join a Forum. So introducing myself it is nice to meet all of you!

Alright the error is simple probably. I tried to search the forum but couldnt solve the issue. I can make a form connected to 2 tables and can input all the information fine. But once I connect it to a third table everything goes bad. First the form went blank. I eventually found out how to fix that.

My new problem is this:

"You can't go to the specified record."
My form is locked basicly and will not let me input new data or use and buttons.

What I am trying to make is a Movie database where I can input all this information about all my movies so I can eventually have a master list of all my movies and I will be able to search them on Name, Genre, Actors or Directors. Any help would be appreciated.

Semer Fi

PS I attached the document and I have no quam starting completly over if it is too jacked up.

 

[Steve R.]

It is easier to create a query, in the query pane. See the DataSourceQRY, which can be used as the data source for your form. Below is the text of the query, copied from the query pane.

SELECT tblActorList.*, tblGenresList.*, tblMovieMain.*
FROM (tblMovieMain INNER JOIN tblActorList ON tblMovieMain.MovieIDNUM = tblActorList.AMovieNameNUM) INNER JOIN tblGenresList ON tblMovieMain.MovieIDNUM = tblGenresList.GMovieNameNUM;

Please note, I have revised your data layout, which I know you did not request. The concern is that the primary key was not being used correctly.

Also you may want to look at your actor list table. If you want a simple database, its OK. However, if you want to have more information about each author you will need to create a different style of author table.

You will need to review normalization.

 

[GarveyUSMC]

Nothing in your zip file possible to upload it again?

 

[Steve R.]

Nothing in your zip file possible to upload it again?

My apologies. It has been uploaded.