MDE woes (and much profanity)

[Taleya]

Has anyone else had this problem?? I have two tables join via an intermediary. One is &quot;clients&quot; the other is &quot;Organisations&quot; The intermediary is a concatenated key for both primaries.<br>
<br>
now, on the organisations form, you can enter in &quot;contacts&quot; (on a subform) The client (ppls I'm doing the DB for) want to be able to call up these contacts from the main clients window, flagged as part of an organisation.<br>
<br>
I have that. I do that. It's rather pretty.<br>
<br>
BUT when you convert it to an MDE...it doesn't happen. <br>
<br>
I'm using the subform with name and email address fields pulled from the CLIENTS table. Data such as what organisation, what address of the organisation etc, are pulled from the active form when you press save:<br>
<br>
Form_qryClubClient1.txtclubname = Form_frmOrganisations.strClubName<br>
Form_qryClubClient1.txtaddress = Form_frmOrganisations.strClubAddress<br>
Form_qryClubClient1.txtCity = Form_frmOrganisations.strclubCity<br>
Form_qryClubClient1.txtpostcode = Form_frmOrganisations.strclubPostalCode<br>
Form_qryClubClient1.Accountant = Form_frmOrganisations.Accountant<br>
Form_qryClubClient1.corporate = Form_frmOrganisations.corporate<br>
Form_qryClubClient1.franchisor = Form_frmOrganisations.franchisor<br>
Form_qryClubClient1.franchisee = Form_frmOrganisations.franchisee<br>
Form_qryClubClient1.estate = Form_frmOrganisations.estate<br>
Form_qryClubClient1.other = Form_frmOrganisations.other<br>
Form_qryClubClient1.Medical = Form_frmOrganisations.Medical<br>
Form_qryClubClient1.property = Form_frmOrganisations.property<br>
Form_qryClubClient1.financial = Form_frmOrganisations.financial<br>
Form_qryClubClient1.state = Form_frmOrganisations.Text86<br>
<br>
As you can see, they're pulled from the current text box data on the org. <br>
<br>
this works. I love it<br>
<br>
BUT IT GOES SCREWY WHEN YOU CONVERT TO AN MDE!!!<br>
<br>
Anyone else had this problem? Any resolutions? (I've tried an SQL string = no soap AGAIN) <p>Taleya<br><a href=mailto:thezoomistress@yahoo.com.au>thezoomistress@yahoo.com.au</a><br><a href=homepages.ihug.com.au/~taleya>Gorillaweed Graphics</a><br>You spam me, I castrate you

 

[DougP]

I don't have a clue as to what your asking or whats going on here.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[Taleya]

in the code when NOT converted to an MDE, it places values into a table from the content of text boxes.<br>
<br>
When converted, it doesn't.<br>
<br>
Simple enough? <p>Taleya<br><a href=mailto:thezoomistress@yahoo.com.au>thezoomistress@yahoo.com.au</a><br><a href=homepages.ihug.com.au/~taleya>Gorillaweed Graphics</a><br>You spam me, I castrate you

 

[JimHorton]

Shouldn't you have a bang instead of dot when referenceing the form fields?<br>
--Jim