POLALA.COM
welcome to my space |
HOME  Populating dropdown formfield based on another |
| Populating dropdown formfield based on another | | Published by: wktd 2009-01-09 |
I need to populate a dropdown formfield, based on what is selected in another dropdown.
I thought I had it, but something strange is happening now.
I populate both fields (Department and Project) via code. The PopulateDepartment subroutine is called from both the Document_New and Document_Open events. Since this form is generated from a template, I figured it needed to be in the NEW event. But since it can also be modified after being created, I put it in the OPEN event also.
ASP web-programming::
It would be nice to see some C# examples or the specifics on another. workarounds. Based on my understanding, for cookie itself, it is not allowed to share
http://qaix.com/asp-web-programming/15.htmlHOME |
The data is loaded into the Department field, then I try to set the default values (which is "..."). I enter the data into an array at the top of the PopulateDepartment subroutine, the loop on that data to load it into the dropdown box. The last thing I do is set the .Result value of the formfield to the first value in the array, which is "...". The exit event for this dropdown executes the PopulateProject subroutine, which reads this value and loads the dropdown with the proper data.
BUT, when PopulateProject is executed, it always gets the value I loaded into the .Result property, regardless of what was selected in the dropdown field. What am I doing wrong????
Parsing a txt file into Word on Microsoft Word VBA Beginners at ::
Then repeat the adding of rows and populating of the cells in that row for Select CheckBox FormField hell ;-) This is a multi-part message in MIME format.
http://www.whitebinder.com/article/468433/microsoft-word-va-txt-file-into-word.aspxHOME |
TriSys 5.00 Software Release Notes::
Another benefit is that any report related errors are identified before the user DbMigration creates a new field: FormField.ScriptOnly.
http://www.trisys.biz/Documents/TriSysSoftwareReleaseNotesV5.aspHOME |
Here is how I load the data into the Department dropdown. I assume the problem is here, since all I am doing in PopulateProjects is getting the .Result of the formfield.
intMax = UBound(mstrDepartment)
Set objFormField = Me.FormFields("cboDepartment")
With objFormField
With .DropDown.ListEntries
.Clear
For intCnt = 1 To intMax
.Add Name:=mstrDepartment(intCnt)
Drop down list to change a form field value? - VBA Express Forum::
add is actually the math equation - addidition, not adding another formfield. to simply insert text into a form field value based on a drop down selection.
http://www.vbaexpress.com/forum/showthread.php?p=92580HOME |
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http ::
access+user+control%27s+type+in+another+usercontrol&access+user+control%27s Returns&cascading+DropDown+List&cascading+DropDown+List&cascading
http://forums.asp.net/p/1281181/2448823.aspx#2448823HOME |
Next intCnt
End With
.Result = mstrDepartment(1)
End With
Now, just b/c I said it and I'm probably wrong, here is some of the code from the LoadProjects subroutine:
intDepts = UBound(mstrDepartment)
Set objFormField = Me.FormFields("cboProject")
With objFormField
With .DropDown.ListEntries
.Clear
.Add "..."
For intDept = 1 To intDepts
If strProject(intDept, 0) = strDept Then
For intProj = 1 To 25
If strProject(intDept, intProj) <> "" Then
.Add Name:=strProject(intDept, intProj)
Else
Exit For
End If
Next intProj
End If
Next intDept
End With
.Result = "..."
End With
:banghead:
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
You are looking at:polala.com's Populating dropdown formfield based on another, click polala.com to home
|
#If you have any other info about this subject , Please add it free.# | |
|
