Re: Drop down listbox connected to MsAccess database

Matt Faus — Sun, 06 May 2007 03:33:16 GMT

Hi reijndert,

First of all, I would suggest that you take a look at this blog post, it might be helpful: http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-a-Query-Filter.aspx

To set the default value of the drop-down you can do this in code by setting the value of the node to one of the values returned from the database. To do this, simply copy the first value from the database results to the node for the drop-down.

Drop down listbox connected to MsAccess database

reijndert — Fri, 01 Dec 2006 10:59:48 GMT

Problem:
In my form I have several dropdown listboxes connected to an msaccess database. How can I 'force' a default selection? I alway get a blanc line as default. In some cases no problem, but sometimes I want to get the default selected without clicking.

Example
=======
listbox1 dataconnection:
select [description] from [department] as [department]

Since this is the first listbox, a blanc default is no problem, you just have to select the rights department

listbox2 dataconnection:
select [name] from [executives] as [executives]

This second listbox gets a filter, based on the departmentcode extracted from listbox1.
(I cannot use a sql-query as filter... Found another solution that worked).

All works fine, but in listbox2 I ALSO get a blanc line as default, even if there is only 1 result!!.

In the case of 1 result I want this result to be defaulted, all other cases a blanc default is no problem.

Any suggestions?

General

Re: Drop down listbox connected to MsAccess database

Drop down listbox connected to MsAccess database