I had this working at one time but now it won't work and I have no idea what I did to make it stop working.

My main form (Companies) has a subform that displays the contacts for the company.

Two issues I'm having trouble with. First, I want to double click on the contact name in the subform and have a form open so that all information for the person can be edited.

Secondly, I have a button on my main form that will open a new data entry form based on the record selected in the subform. This form is used to enter information about phone calls made to that person so each time it's opened it's a new record.

I have read about the syntax for using main/subforms until I can't read anymore and everything I try won't work. :(

Thanks for any help you can provide.

You haven't given us much to work with. Maybe posting your db will help. Remove any sensitive data of course.

If you can give me some clue on how to get my zipped DB to less than 300KB than I'll attach it. In the meantime, I've attached a very blurry pdf of my forms and what I'm hoping to do. I hope this will help. If not, let me know how I can explain it better.

Again, thanks for any help you can give.

After you Compact and Repair and then ZIP it, what size are you dealing with? It needs to be < 394 KB to post here.

How about posting your DoubleClick code and the Click code for the button? Then we can make some suggestions.

The compacting and repair must have taken care of the size issue because now it's small enough to upload (attached).

The code that I have for the double click and for opening the form is probably so messed up because I've tried so many different form syntax.

Here's a link you should have in your favorites:
http://www.mvps.org/access/general/gen0018.htm

You will do yourself a great favor if you stopped using spaces in the names of objects.