Access97 losing customer details

[giggly]

Hello and thanks for looking,


My problem is access 97 database is losing my customer details ?? the quotations are still there but no details for the customer e.g address, name, customer ID all gone so to view the quotation i have to type address and details all again, really don't know what could be causing this to happen , everything is fine I shut down access and open back up again address still there but if I close Access and shut down computer that's when i seem to be losing information ??? please help if poss as its doing my swede in !
many thanks in advance
Steve

[June7]

No way of knowing without examining the db and don't know if I could even open a 97 file.

Did this used to work properly? What has changed?

[giggly]

yes always worked good, never had this problem before, Ive added a few drop down boxes and I think I added an input mask to customers table (first and last name) to capitalize first letter, this never worked and I totally forgot to remove, which i have now so perhaps this is the root of the problem ?? I'll keep an eye open and post back if this problem is sorted. many thanks for getting back to me June7
Best wishes
Steve