repeating drop down

[FrankS]

Using SP1 and managed code I populate a repeating table. OK fine. Now I want
to have one of the columns to be changed with a drop-down list (let's say
from a data source). I have tried several combinations and cannot get the
value to change with the context change in the drop down.

Ideas please.

 

[Jerry Thomas [MSFT]]

Greg Collins, one of our MVP's has a site with a couple of topics that might
help you out.
http://www.infopathdev.com/examples/


--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

 

[FrankS]

Jerry, I guess I was not clear I have reviewed all the suggestions in all the
blogs I can find including Gregs several times. Perhaps I missed it, but... I
am not trying to populate a drop down. I already have that. I am trying to
*change* a cell in a repeating table with a drop down (in the same cell)
after the repeating table has been populated by a source (doesn't matter
where from). I have tried every combo of rules and code I can think of.

Example:
This row is populated from a source in the repeating table:
Name State
Frank AZ

Now I want to change the State with a drop-down in the state column with the
default being the current value (in this case AZ). In other words, the
drop-down is in the State cell and defaulted to the DB value unless changed
in the drop-down.

I can get it to work with a second drop-down of states and then *ruling* the
selected value to the repeating table field however I would like the
drop-down to default to the current value in the same cell.

Thanks,
Frank

Greg Collins, one of our MVP's has a site with a couple of topics that might
help you out.
http://www.infopathdev.com/examples/


--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Using SP1 and managed code I populate a repeating table. OK fine. Now I want
to have one of the columns to be changed with a drop-down list (let's say
from a data source). I have tried several combinations and cannot get the
value to change with the context change in the drop down.

Ideas please.

 

[Jerry Thomas [MSFT]]

You want to change Frank from living in AZ to WA?
Let me think on this one...

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Jerry, I guess I was not clear I have reviewed all the suggestions in all the
blogs I can find including Gregs several times. Perhaps I missed it, but... I
am not trying to populate a drop down. I already have that. I am trying to
*change* a cell in a repeating table with a drop down (in the same cell)
after the repeating table has been populated by a source (doesn't matter
where from). I have tried every combo of rules and code I can think of.

Example:
This row is populated from a source in the repeating table:
Name State
Frank AZ

Now I want to change the State with a drop-down in the state column with the
default being the current value (in this case AZ). In other words, the
drop-down is in the State cell and defaulted to the DB value unless changed
in the drop-down.

I can get it to work with a second drop-down of states and then *ruling* the
selected value to the repeating table field however I would like the
drop-down to default to the current value in the same cell.

Thanks,
Frank

Greg Collins, one of our MVP's has a site with a couple of topics that might
help you out.
http://www.infopathdev.com/examples/


--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Using SP1 and managed code I populate a repeating table. OK fine. Now

I
want

to have one of the columns to be changed with a drop-down list (let's say
from a data source). I have tried several combinations and cannot get the
value to change with the context change in the drop down.

Ideas please.

 

[Jerry Thomas [MSFT]]

I apologize if I am missing something...
You can have your states field as a drop down, linked to a list of states
(hand entered or in a seperate form or db), and the main db will store the
entry last selected. If Frank moves from AZ to WA then when you submit, WA
will get stored in your db.
--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Jerry, I guess I was not clear I have reviewed all the suggestions in all the
blogs I can find including Gregs several times. Perhaps I missed it, but... I
am not trying to populate a drop down. I already have that. I am trying to
*change* a cell in a repeating table with a drop down (in the same cell)
after the repeating table has been populated by a source (doesn't matter
where from). I have tried every combo of rules and code I can think of.

Example:
This row is populated from a source in the repeating table:
Name State
Frank AZ

Now I want to change the State with a drop-down in the state column with the
default being the current value (in this case AZ). In other words, the
drop-down is in the State cell and defaulted to the DB value unless changed
in the drop-down.

I can get it to work with a second drop-down of states and then *ruling* the
selected value to the repeating table field however I would like the
drop-down to default to the current value in the same cell.

Thanks,
Frank

Greg Collins, one of our MVP's has a site with a couple of topics that might
help you out.
http://www.infopathdev.com/examples/


--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Using SP1 and managed code I populate a repeating table. OK fine. Now

I
want

to have one of the columns to be changed with a drop-down list (let's say
from a data source). I have tried several combinations and cannot get the
value to change with the context change in the drop down.

Ideas please.

 

[FrankS]

Thanks Jerry.

I apologize if I am missing something...
You can have your states field as a drop down, linked to a list of states
(hand entered or in a seperate form or db), and the main db will store the
entry last selected. If Frank moves from AZ to WA then when you submit, WA
will get stored in your db.
--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Jerry, I guess I was not clear I have reviewed all the suggestions in all the
blogs I can find including Gregs several times. Perhaps I missed it, but... I
am not trying to populate a drop down. I already have that. I am trying to
*change* a cell in a repeating table with a drop down (in the same cell)
after the repeating table has been populated by a source (doesn't matter
where from). I have tried every combo of rules and code I can think of.

Example:
This row is populated from a source in the repeating table:
Name State
Frank AZ

Now I want to change the State with a drop-down in the state column with the
default being the current value (in this case AZ). In other words, the
drop-down is in the State cell and defaulted to the DB value unless changed
in the drop-down.

I can get it to work with a second drop-down of states and then *ruling* the
selected value to the repeating table field however I would like the
drop-down to default to the current value in the same cell.

Thanks,
Frank

Greg Collins, one of our MVP's has a site with a couple of topics that might
help you out.
http://www.infopathdev.com/examples/


--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.


Using SP1 and managed code I populate a repeating table. OK fine. Now I
want
to have one of the columns to be changed with a drop-down list (let's say
from a data source). I have tried several combinations and cannot get the
value to change with the context change in the drop down.

Ideas please.