Can not show SubForms or Lists

[Robert M]

I create a table that is created my a vba program that list unused numbers (formated as text) from another table.
What I am trying to do is get a list of the unused numbers so as to have an easier time of assigning those numbers to the main records.

When I pull up the form that is supposed to allow me to do this I get the list of records shown at times, at other times they are shown but after I start entering data they change to "#Deleted " or just come up with "#Deleted" being shown.

As these numbers are not already linked to any records, or the main records. what can be done to inable the form to show the unused numbers without having the fields go to "#Deleted"?

Thank you for your time and help in this matter.

Robert M

 

[vbaInet]

We will need to see the db to see exactly how and when this happens. Upload a stripped down version of your db and tell us how to replicate the problem.

 

[Robert M]

Thank you vbaInet, I have been playing around with different scenarios and have solved the problem by creating 2 tables. The main table for active Numbers and another table for Inactive numbers. What I am working on now is a vba program that will run through the list of active numbers and list the inactive programs. To do this I will first have to delete the contents of the Inactive table then check the Active table and load the Inactive table with the Inactive numbers.

Thanks for your help with this matter. And my applogies for taking your time.

Robert M.

 

[vbaInet]

Good to see that you managed to get a working solution.

From what you explained deleting from one table isn't necessary but then again I didn't get the full picture.

 

[Robert M]

True. But the seperate Table was what was getting me in trouble as it was not tied to the Main table. So I am having to go with the Status table that IS tied to the Main table and work out a seperation field. I have pretty much got it figured out except how to change the field rather than add new ones.

Thanks again for your help and input.

Robert M

 

[vbaInet]

Ok. In order for me to see the full picture, I will need to see a mock-up db.

 

[Robert M]

Sure thing vbaInet, soon as I get the programing done. be a few days.

Robert M

 

[vbaInet]

We can wait!