Code

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Wed, 09 Nov 2011 01:44:45 GMT

So now that you asked.....I have developed a very robust Database surgical practice management system that is client/server based and has been running for about 10 years.

This (nfopath form ) is the 'medical record ' part of that app. It will be pullling most of the information in from the db; but if it submits any information back I plan on implementing that task in code.

The forms will be stored with an index pointer in the db (the index will be created in the db and pulled into the form using a parameter when the form starts..then saved using the unique record pointer....and signed to lock either all or part of the record.

You are correct that I am unfamiliar with infopath...but I appreciate the suggestions...

I will be beta testing this for a while until we smooth out the kinks ( I actually have to build a custom ActiveX control for this form ..ugh...if you do any work with custom ActiveX controls let me know !!...that is really something I don't want to do)

adam

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Wed, 09 Nov 2011 00:46:10 GMT

So, ummmm.... I know you haven't asked for advice, here, but just in case you need some...

When you say:

JAWSURGEON:
this form will be linking to an existing AccessDB and later to SQL DB

What do you mean, exactly? Are you intending to write code in the form to submit it to your DB? Or use a web service, or some other approach? I ask in case you are unfamiliar with InfoPath and submitting to databases - with InfoPath, if you want to take advantage of the native capabilities for submitting to databases, you actually have to build your database first, then base the form off it. And I don't believe it is possible to switch from Access to SQL at a later point (without rebuilding the form) - I may be wrong about that piece, but I was concerned you may be under the misapprehension that you can build your form and just add a submit button and have it submit to a DB. If you intend to build a DB bound form, I'd recommend you start with SQL to begin with (and, in general, I'm not a fan of DB bound forms as I find the tight coupling to be frustrating at the very least and often infuriating) - SQL has a free "Express" SKU that would be enough to get you started...

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Tue, 08 Nov 2011 20:26:38 GMT

I agree totally.....I have learned over many years that nomenclature and naming conventions are really important !!

I am only 2 weeks into this project in between 10 gazilliion other things !! But this form will be linking to an existing AccessDB and later to SQL DB...so things need to be tidy.

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Tue, 08 Nov 2011 19:39:15 GMT

Oh, great, glad that worked for you. As an aside - if this form is not in production yet, you'll want to be sure to tidy up your main data source before it is (I can tell by the way you are naming things that this is most likely your intent, but I since I noticed it, I thought I'd remind you). It is always hard to figure out what field123 is after a few months in production when you go to make a change to the template. :)

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Tue, 08 Nov 2011 19:04:50 GMT

Great thanks so much for the tip.

Works just fine !!

...This project is just beginning and I am sure to have more questions.

All the Best.

Adam

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Tue, 08 Nov 2011 15:44:05 GMT

So, I've added a rule to the cboICDMCode field. It sets the value of the my:fldICDM_Text field. It uses the current() function in the filter for the formula for the value.

Give this a try - you'll need to disable your current code on the field to verify the rule is working (if there is code on the field in this copy). Right click the link in the message header, save the file locally, right click the saved file and select design to open in design mode.

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Tue, 08 Nov 2011 03:17:05 GMT

Ok...uploaded.

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Tue, 08 Nov 2011 01:43:52 GMT

Can you attach your form to a reply? Under the Options tab...

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Tue, 08 Nov 2011 01:37:07 GMT

Hillary:

I have spent some time trying to get the 'rules" based approach to accomplish what we just did in code..because it seems like it would be faster to implement..but I can't get it to work. I tried editing the xpath in the rule ..but that did not work.

So what I want to accomplish is ;

ComboBox1 : strIProcCode>>use makes choice >>>rule fires >>>>populate TextBox with strProcCodeDesc

I set up a 2 column repeating table with : comboBox1 and txtDescription

Also setup a repeating section with the same fields: combobox1 and txtDesription

I can get the comboboxes to select unique values; but the value in txtDescription remains the same thing...always;

The Field I want to set is: /my:myFields/my:Exam/my:group106/my:group107/my:fldProcText; however I cannot enter or change the value in the Rules editor.

The Value I want in the text box is: xdXDocument:GetDOM("tblProcCodes")/dfs:myFields/dfs:dataFields/d:tblProcCodes[@strProcCode = '" & e.newvalue * "']/@strProcCodeDesc

There must be something easy that I am missing !!!

thanks

Adam

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Tue, 08 Nov 2011 01:37:03 GMT

Hillary:

So what I want to accomplish is ;

ComboBox1 : strIProcCode>>use makes choice >>>rule fires >>>>populate TextBox with strProcCodeDesc

I set up a 2 column repeating table with : comboBox1 and txtDescription

Also setup a repeating section with the same fields: combobox1 and txtDesription

I can get the comboboxes to select unique values; but the value in txtDescription remains the same thing...always;

The Field I want to set is: /my:myFields/my:Exam/my:group106/my:group107/my:fldProcText; however I cannot enter or change the value in the Rules editor.

The Value I want in the text box is: xdXDocument:GetDOM("tblProcCodes")/dfs:myFields/dfs:dataFields/d:tblProcCodes[@strProcCode = '" & e.newvalue * "']/@strProcCodeDesc

There must be something easy that I am missing !!!

thanks

Adam

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Mon, 07 Nov 2011 21:07:52 GMT

This fixed it...now it works. I had to use the "../"

ICDMcode.SelectSingleNode(

"../my:fldICDM_Text", Me.NamespaceManager).SetValue(ICDMdescr)

I am still going to try to figure how to do the non-programmatic method since its a heck of a lot easier.

Regards,

Adam

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Mon, 07 Nov 2011 20:50:17 GMT

You don't want to confuse controls on the form with the actual schema structure of the form. Repeating groups can bound to a number of controls - repeating tables, repeating sections, sections that don't repeat, etc.

As long as the field bound to the combo box is in the same repeating group as the field bound to the text box, you should be able to use a relative XPath.

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Mon, 07 Nov 2011 20:46:07 GMT

Well its not actually in a repeating group; its in the first column of a repeating table (not sure if that distinction is important here).

I am going to return to this later this evening...and work on it.

Thanks for now. I will touch base tomorrow if needed.

Thanks again for all your input.

Adam

Re: Getting value from ComboBox Secondary Data into a Text Field

Hilary Stoupa — Mon, 07 Nov 2011 20:41:45 GMT

If the field the combo box is bound to is in the repeating group, then it should be able to set the value of a field within the repeating group when it changes - and only the field in that instance. Attach your template under the Options tab of a reply if you'd like me to set up a rule so you can see that.

ICDMcode is the current repeating node, right? I see you are using e.Site. The problem again, then, is your XPath - it needs to be relative. I'll guess that ICDMcode is actually at the current instance of my:grpICDMCodes...

ICDMcode.SelectSingleNode("my:fldICDM_Text", Me.NamespaceManager).SetValue(ICDMdescr)

Re: Getting value from ComboBox Secondary Data into a Text Field

JAWSURGEON — Mon, 07 Nov 2011 20:31:39 GMT

1. The Dim ICDMdescr as string...indeed retrieves the appropirate value !! thanks

2. Since this is a repeating table; the combo box on EACH line needs to insert the right text into that text box on it's own line.

the following code only inserts it on FIRST line of the table and no others....

ICDMcode.SelectSingleNode(

"/my:myFields/my:Exam/my:grpICDM/my:grpICDMCodes/my:fldICDM_Text", Me.NamespaceManager).SetValue(ICDMdescr)

I am guess I need to select the parent node or some other device to select the proper correspongind test box

Code 1............................................Code1 description

Code 2...........................................Code 2 description

and so forth...

BTW...I tried creating a 'rule' that looks up the data value after the user selects the combobox item... once again this has the disadvantage that it puts the same descripton in very line item.

Thanks for all you help in advance.

ADam