Ok, I have a form set up to pull some information that is set up as a combo box. When I create the form it works, the information is there. I save it close it out reopen it and it gives me a message like it has been renamed or deleted. I did not rename the table or delete it. I delete the form and then make a new one, everything works. I save it, close it and then reopen it I get the message. Any help would be great!!!!
Form not pulling correct information from a table
- Thread starter SgtRoss
- Start date
Ok, let me try and explain this again seeing that my first post did not explain it well. I have a table named Job table. This table lists all the jobs for the inmates, I have another table named Inmate Information. Inside the inmate information table I have a field for jobs. It is set up as a combo box with the source as select[job table].[job]from[job table]. The correct information is displayed in the inmate information table. I then created a form to enter all the information. When I first made the form it displayed all the jobs. I closed it and then re-opened the form and when I click on the drop down arrow to display the available jobs I get a message saying that it has either been deleted or renamed or no longer part of the data base. I am stumped. I created another data base for another facility and it works just fine. I can not figure out what I am doing wrong. Any help would be great!!!!!
Similar threads
