Controls

Re: List Box and SQL Data Connection

norale — Thu, 15 Nov 2007 03:10:32 GMT

Hi Clay,

The data is from sql database.

Something wrong with my data connection and I fix it already.

Sorry for buging you.

Thanks for the help anyway. :)

Re: List Box and SQL Data Connection

Clay Fox — Wed, 14 Nov 2007 13:25:50 GMT

Well if you drag the repeating group from your secondary data connection on to your form and it only shows one row then that is your issue not the setup in the list control.

You may want to set up your data connection again. By default you should get all rows of the table. Is this an Access table? Where is the data coming from?

Re: List Box and SQL Data Connection

norale — Wed, 14 Nov 2007 07:40:57 GMT

Hi Clay,

FYI, i've done steps 2 and 3 and came out with the same result.

I've try as u suggested in step 1, and it appear to show only 1 data (data from the first row)..

In the secondary data connection, do I have to set anything (e.g. sql statement) in order to retrieve all the data in the table?

Re: List Box and SQL Data Connection

Clay Fox — Wed, 14 Nov 2007 06:29:38 GMT

The list box should be bound to a field in your main data source. Then use the secondary connection as the source for the list. I am guessing that your list box is bound directly to a field in the data connection which is not how you want to set it up.

1 would be to drag a repeating table on to verify what is coming in via your secondary data connection.

2 add a list control to your form which should automatically create a new field.

3 go into the properties of the list control and select to use values from an external data source and select your data connection from the dropdown.

Play around with it.

Hope this helps.

List Box and SQL Data Connection

norale — Wed, 14 Nov 2007 04:18:54 GMT

Hi,

I try to populate list of name in the list box. I get the data from sql secondary data connection. The problem is, the list box only display data at the first row of the table. How can i populate all the data in the table into the list box?

Thanks.