Address Book on Form

[razorkat99]

I have an address book in my form that I am trying to get working and have come to a dead end. It is the same address book as the one in the Access standard test database.

I have attached the db for assistance. I have the form separate for now as AddressBook1, but it will eventually need to be added to the CustomerCallsDataEntryFrm. I just need to get it to work first. I did a simple stand alone db and got it to work just fine, but I can't figure out why this one isn't working when all I did was change the table/field names to match my current db.

I continue to get the "lost network connection" error due to my db not dropping the link in VBA when I delete a form that had an event procedure written into it. Driving me crazy, but will deal with that later. So, if you get that, don't worry about it.

Form: AddressBook1
Table: tblLocation
Query: Addresses Alphabetized

Any help would be grateful. Thanks.

 

[boblarson]

First of all, how did you populate the code for AddressBook1? I am getting compile errors that either suggest form corruption or that you manually typed the events in.

 

[boblarson]

Okay there is some corruption going on. I just imported everything (except the form "Address") into a blank MDB file. It seems to have fixed the problems.

 

[razorkat99]

I don't know why this db keeps getting corrupted every time I turn around, but it's getting REALLY annoying having to pull everything into a new db. I also don't know why it didn't work yesterday even when I wasn't getting the errors. All I know is I'M HAPPY NOW!!!! THANK YOU!!!