HELP! Company DB acting up all of the sudden!

[denileigh]

I have no idea what is going on. I have a tabbed form with a combo box to select customers. I have a combo underneath it that updates to select the contact once the customer is selected.

It has been working a-ok for almost a year now but all of the sudden it works but doesn't save the contact info!!! If you select it & print the work order it works great but if you close the form and go back into it, the contact info is gone.

Can anyone help!

 

[ghudson]

Have you made any recent changes to the design of the db or the VBA?

Does your code compile?

Have you recently repaired and compacted your db? If not, you should.

How does your db backup file behave? The same [problem] or like it should [used to]?

 

[denileigh]

Thanks for your response. Sorry for the delay. Had surgery on Friday. Back at work now and trying to fix the problem.

I have done none of the above nor do I have a back up. It is so wierd. It is storing the data in the table & even printing it out on forms/reports but after I add a new job, close the form, or go back, the data isn't showing.

I checked the column settings in the properties but I don't see a problem there either.

Any ideas? It seems to be only a display issue on the form.

 

[ghudson]

If the new data is really being stored in the table then your form might have a relationship problem with your data. It probably has been there all along, maybe not.

Try to rebeuild the SQL or query to your forms record source until you are able to display the form records the way you want it.

 

[denileigh]

Didn't work. It displays on some but not others.

Any other ideas?