Combobox in a grid

TheMSsForum.com: The Microsoft Software Forum

I need some help. Right now i have a grid with 10 columns. All the columns
are using "text" to display the information but I need to use a combobox in a
column named "country". At the moment i have the following code but when the
cursor
enter that column then the combobox doesnt allow me to pick any other country

Grid.Name = GrdTempDetail
Grid.RecordSource = TempDetail

Column country information
GrdTempDetail.GrcCountry. countrolsource = tempdetail.country
GrdTempDetail.GrcCountry.combobox.countrolsource = tempdetail.country
GrdTempDetail.GrcCountry.combobox.recordsource = country.country
GrdTempDetail.GrcCountry.combobox.type = alias

The table country has 5 records at the moment.
1)USA
2)Canada
3)France
4)Italy
5)Mexico

What do i need to do to be able to show the combobox with all the countrys
and be able to pick a different one?

Thank for the help
Eliseo
Top

Re: Combobox in a grid by EliseoNegrin

EliseoNegrin
Thu Feb 21 11:09:01 CST 2008

Yes, I meant RowSourceType !
Tried the value to 6 and it doesnt work either.

Right now I can see the combobox but when I click in the down arrow of the
combobox, it doesn open to show the countries that i can select.


> I assume that you meant:
>
> GrdTempDetail.GrcCountry.combobox.*RowSource*type = alias
>
>
> Try setting that value to 6 (Fields)
>
> - Rush
>
>
Top

Re: Combobox in a grid by Rush

Rush
Thu Feb 21 10:47:38 CST 2008

This is a multi-part message in MIME format.
--------------040303020103000103080807
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Eliseo Negrin wrote:
> I need some help. Right now i have a grid with 10 columns. All the columns
> are using "text" to display the information but I need to use a combobox in a
> column named "country". At the moment i have the following code but when the
> cursor
> enter that column then the combobox doesnt allow me to pick any other country
>
> Grid.Name = GrdTempDetail
> Grid.RecordSource = TempDetail
>
> Column country information
> GrdTempDetail.GrcCountry. countrolsource = tempdetail.country
> GrdTempDetail.GrcCountry.combobox.countrolsource = tempdetail.country
> GrdTempDetail.GrcCountry.combobox.recordsource = country.country
> GrdTempDetail.GrcCountry.combobox.type = alias
>

I assume that you meant:

GrdTempDetail.GrcCountry.combobox.*RowSource*type = alias


Try setting that value to 6 (Fields)

- Rush


--------------040303020103000103080807
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Eliseo Negrin wrote:
<blockquote
cite="mid:E9C3F8DF-7E9E-4439-9D5C-697088132BF7@microsoft.com"
type="cite">
<pre wrap="">I need some help. Right now i have a grid with 10 columns. All the columns
are using "text" to display the information but I need to use a combobox in a
column named "country". At the moment i have the following code but when the
cursor
enter that column then the combobox doesnt allow me to pick any other country

Grid.Name = GrdTempDetail
Grid.RecordSource = TempDetail

Column country information
GrdTempDetail.GrcCountry. countrolsource = tempdetail.country
GrdTempDetail.GrcCountry.combobox.countrolsource = tempdetail.country
GrdTempDetail.GrcCountry.combobox.recordsource = country.country
GrdTempDetail.GrcCountry.combobox.type = alias
</pre>
</blockquote>
<br>
I assume that you meant:<br>
<br>
<pre wrap=""> GrdTempDetail.GrcCountry.combobox.<b>RowSource</b>type = alias
</pre>
<br>
Try setting that value to 6 (Fields)<br>
<br>
 - Rush<br>
<br>
</body>
</html>

--------------040303020103000103080807--
Top

RE: Combobox in a grid by CathyNeppel

CathyNeppel
Thu Feb 21 13:33:01 CST 2008

A couple of things to check

- Make sure the column with the combobox set with the ActiveControl = to the
combobox name
- Make sure the combobox and column Enabled = .T.

If the data in the table has "Mexico" for the country, does "Mexico"
actually show in the combobox or is it always blank?

"Eliseo Negrin" wrote:

> I need some help. Right now i have a grid with 10 columns. All the columns
> are using "text" to display the information but I need to use a combobox in a
> column named "country". At the moment i have the following code but when the
> cursor
> enter that column then the combobox doesnt allow me to pick any other country
>
> Grid.Name = GrdTempDetail
> Grid.RecordSource = TempDetail
>
> Column country information
> GrdTempDetail.GrcCountry. countrolsource = tempdetail.country
> GrdTempDetail.GrcCountry.combobox.countrolsource = tempdetail.country
> GrdTempDetail.GrcCountry.combobox.recordsource = country.country
> GrdTempDetail.GrcCountry.combobox.type = alias
>
> The table country has 5 records at the moment.
> 1)USA
> 2)Canada
> 3)France
> 4)Italy
> 5)Mexico
>
> What do i need to do to be able to show the combobox with all the countrys
> and be able to pick a different one?
>
> Thank for the help
> Eliseo
>
Top

RE: Combobox in a grid by EliseoNegrin

EliseoNegrin
Thu Feb 21 14:17:01 CST 2008

Cathy,
1) The column has combobox as the control
2) Both are enabled
3) To answer your question -> It always show blank !



> A couple of things to check
>
> - Make sure the column with the combobox set with the ActiveControl = to the
> combobox name
> - Make sure the combobox and column Enabled = .T.
>
> If the data in the table has "Mexico" for the country, does "Mexico"
> actually show in the combobox or is it always blank?
>

Top

Re: Combobox in a grid by Stefan

Stefan
Fri Feb 22 11:45:18 CST 2008


Does the combo work better when you use a rowSourceType which
does not require an open alias?, e.g. what happens when you either
use RowSourceType=0 and then in combo.Init() add items manually:
This.AddItem("1)USA")
This.AddItem("2)Canada")

Or, if the prvious version does what you want, fill it dynamically in
combo.Init():
This.AddProperty('aRowsource[1]')
Select theField From theLookupTable Into Array (This.aRowsource)
This.RowSource = 'This.aRowsource'
This.RowSourceType = 5



hth
-Stefan


"Eliseo Negrin" <EliseoNegrin@discussions.microsoft.com> schrieb im Newsbeitrag
news:F92BABB9-F80C-4709-A76C-44F191A4874D@microsoft.com...
> Yes, I meant RowSourceType !
> Tried the value to 6 and it doesnt work either.
>
> Right now I can see the combobox but when I click in the down arrow of the
> combobox, it doesn open to show the countries that i can select.
>
>
>> I assume that you meant:
>>
>> GrdTempDetail.GrcCountry.combobox.*RowSource*type = alias
>>
>>
>> Try setting that value to 6 (Fields)
>>
>> - Rush
>>
>>



--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------


Top

Re: Combobox in a grid by EliseoNegrin

EliseoNegrin
Mon Feb 25 10:55:06 CST 2008

Thank you
I was able to solve it using your code below

"Stefan Wuebbe" wrote:
> Or, if the prvious version does what you want, fill it dynamically in
> combo.Init():
> This.AddProperty('aRowsource[1]')
> Select theField From theLookupTable Into Array (This.aRowsource)
> This.RowSource = 'This.aRowsource'
> This.RowSourceType = 5
>
>
>
> hth
> -Stefan
>
>
> "Eliseo Negrin" <EliseoNegrin@discussions.microsoft.com> schrieb im Newsbeitrag
> news:F92BABB9-F80C-4709-A76C-44F191A4874D@microsoft.com...
> > Yes, I meant RowSourceType !
> > Tried the value to 6 and it doesnt work either.
> >
> > Right now I can see the combobox but when I click in the down arrow of the
> > combobox, it doesn open to show the countries that i can select.
> >
> >
> >> I assume that you meant:
> >>
> >> GrdTempDetail.GrcCountry.combobox.*RowSource*type = alias
> >>
> >>
> >> Try setting that value to 6 (Fields)
> >>
> >> - Rush
> >>
> >>
>
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>
>
>
Top

Re: Combobox in a grid by Stefan

Stefan
Mon Feb 25 14:40:40 CST 2008


You are welcome!


"Eliseo Negrin" <EliseoNegrin@discussions.microsoft.com> wrote in message
news:539E6A58-3B38-4B6E-A52A-8EB27CE39B3E@microsoft.com...
> Thank you
> I was able to solve it using your code below
>
> "Stefan Wuebbe" wrote:
>> Or, if the prvious version does what you want, fill it dynamically in
>> combo.Init():
>> This.AddProperty('aRowsource[1]')
>> Select theField From theLookupTable Into Array (This.aRowsource)
>> This.RowSource = 'This.aRowsource'
>> This.RowSourceType = 5
>>
>>
>>
>> hth
>> -Stefan
>>
>>
>> "Eliseo Negrin" <EliseoNegrin@discussions.microsoft.com> schrieb im
>> Newsbeitrag
>> news:F92BABB9-F80C-4709-A76C-44F191A4874D@microsoft.com...
>> > Yes, I meant RowSourceType !
>> > Tried the value to 6 and it doesnt work either.
>> >
>> > Right now I can see the combobox but when I click in the down arrow of
>> > the
>> > combobox, it doesn open to show the countries that i can select.
>> >
>> >
>> >> I assume that you meant:
>> >>
>> >> GrdTempDetail.GrcCountry.combobox.*RowSource*type = alias
>> >>
>> >>
>> >> Try setting that value to 6 (Fields)
>> >>
>> >> - Rush
>> >>
>> >>
>>
>>
>>
>> --
>> |\_/| ------ ProLib - programmers liberty -----------------
>> (.. ) Our MVPs and MCPs make the Fox run....
>> - / See us at www.prolib.de or www.AFPages.de
>> -----------------------------------------------------------
>>
>>
>>


Top