Hyperlink from subform issue

[vad77]

Hope all is well with everyone. I have a form called "Main_Site_Informatiom" and on that form there are 3 subforms. One for site contacts, one for site techs and the last for site equipment.


On the subform for site contacts I created a "Click" event on the "ContactID" field to open the ContactsAdd form when I click on a contact ID. The code is...

DoCmd.OpenForm "fContactAdd", acNormal, , "[ContactID]=" & [Forms]![main_site_information]![sfrm_SiteInfoContacts].Form![ContactID], , acWindowNormal

This works and the form opens on the contact ID that I click.

I also want the same function on my tech subform. So I copied and pasted the code above in the "Click" event of my TechID field on the tech subform then changing the field names.

DoCmd.OpenForm "fHHCTechs", acNormal, , "[techID]=" & [Forms]![main_site_information]![sfrm_SiteInfoTechs].Form![TechID], , acWindowNormal

When I click on a tech ID I get a pop-up titled "Enter Parameter Value". In the box above the input field is the tech id that I clicked. I don't understand why it is acting this way. The form that this code is opening does have Filter on Load set to yes. If I enter the techID in the popup it opend the form to that tech.
Thank you in advance for your assistance.

[NTC]

this is a parameter prompt. either the form, or its record source can't find that field... in the form look both in its set of fields but also look at the Order By property for any reference to it....also in any combobox record sources....

[vad77]

ank you NTC for your response, I checked the items you stated and I don't see any of those things set. The only combo boxes I have are to look up an acount by region then by name. I tried to create a new query for the subform and did not make a difference. Then I deleted the subform by mistake and when I created it again I got a totally different error.
Something about Access had an error communicating with the OLEserver or Active X Control. Don't know what I did but I back up the database in the morning so I am going to use that one and start over with the linking procedures. I got it working on 2 of the 3 subforms and would try again hopefully with better results. I have 3 databases I am working on right now and hve to switch attention between these 3.
Thanks I will let you know how it turns out. I will leave this open for now or until I complete the task and will post my results.