'new contact' button???

[Cavern]

I've got a list of companies, and a form to edit their information. But I also have a list of communications with each company (with name of contact, date, etc..) in a seperate table. I'm trying to figure out how to create a button on my form that will bring up another form to add a new contact (ie. with the company ID already filled in to the record I was just on). Because of space restrictions I can't use a straight list-subform.
Is this possible? How should I go about setting it up? Is there a better way to do it?

Thanks for your patience with an access newbie
-Cavern

 

[fernin8r]

From what i understand. you have one form with Company ID and some other information. on that form you would like to have a button that opens another form. the second form contains a Company ID and some other information as well. Is the problem you are having, when you open up the second form you would like it to already have the same Company ID as in the first form?

if so, just set the default value to Forms![First Form]![Company ID].

Let me know if this is what you were wondering?

 

[Cavern]

Worked like a charm Thanks alot.