Working form no longer working after change in tables

[Robert M]

I had two tables, one for Client Names. One for Client Addresses.
Since I have found that Client Addresses can change from time to time without affecting the other Client names with that Address, I merged the two tables into one.
Now my Data entry form is not working.
What have I done?

Thanks for your help on this issue.

Robert M

 

[AccessMSSQL]

Can you explain further - what isn't working in your main form. Did you modify your main form so that it is using the new merged table. Are you getting any errors in your main form?

 

[Robert M]

The form was working fine when I had the Client and Address in two seperate tables. However, on merging the two tables into one, updating the quiries to reflect the single table as well as having the form in question Data pointing to the table. I am now no longer able to add anything to the form.

 

[pr2-eugin]

What is the Form's RecordSource? See if it looking into the right table.. If you had any relationships established between the two tables earlier, delete them and try adding fields.. if none of them works.. try uploading a mdb (preferably A2000) version so we can have a look at it..

 

[Robert M]

Thanks for your help pr2, I'll double check on that and post it back on this forum.

 

[Robert M]

Solved It! The form was using qryFullListing to get all the fields in all the tables filled. What I might have done was not have all the pointer fields in the qry. I removed all tables for that qry, then reloaded the tables making sure all fields in all the tables, including the pointers, were included in the qry. It now works.

Thank you for your help and suggestions, that is what got me going to find the solution.

Robert M