Multiple Combo Boxes writing to one field

Question

Hi
I am building a form in AP 8 where I have multiple combo boxes hosting .dbf drop-down lists, all set to write to the same attribue field. The visibility of each combo box is determined by a series of radio buttons so that only one combo box at any time will be able to return a value.
However I can't get the attribute table to populate. Do I have to de-activate the invisible combo boxes or set the visible one to active or something?

Anyone know any scripts to do this?

thanks
Steve

SteveH · Answer

Hi

So what you have is a combobox with say...trees,shrubs,grasses and when select 'trees, the second combobox only loads up with tree species??

Mark

Precisely.
And before you ask the code is below. In this case item chosen from a dbf list linked to "cmbActn" will populate the combobox "cmbWrkMthd"

sub SelectList 'sub to select specific entires from a dbf file for inclusion in dropdown menu on form, based on previous choice

dim pLayer, pAction, pWorkMethod, filepath, GetPath
 
 set pLayer = Application.map.selectionLayer.Forms("EDITFORM")
 pAction = pLayer.Pages("PAGE3").Controls("cmbActn").value
  
 set pWorkMethod=pLayer.Pages("PAGE3").Controls("cmbWrkMthd")
 if pWorkMethod.ListCount > 0 then
  pWorkMethod.Clear
 end if
GetPath = Left(application.map.selectionlayer.FilePath, InStrRev(application.map.selectionlayer.FilePath, "\"))

if pAction <> "" then
  filePath = GetPath & "WorkMethod.dbf"
  pWorkMethod.AddItemsFromTable filePath, "Method", "Method", "[ACTION] = """& pAction & """"

end if

end sub 'SelectList

and the dbf for the second combobox (in this case WorkMethod.dbf) must look like this:
ACTION         METHODTXT                                      
Weed Control Spray - Chemical            
Weed Control Spray - Rust           
Weed Control Hand Removal            
Weed Control Other (Please Type)   
Fencing         Standard Fence            
Fencing         Other (Please Type)    
Revegetation Reveg with Indigenous Vegetation 
Revegetation Other Reveg (Plse Type)

hope that helps

cheers
Steve H

markfarina · Answer

Hi

So what you have is a combobox with say...trees,shrubs,grasses and when select 'trees, the second combobox only loads up with tree species??

Mark

SteveH · Answer

Thanks Eric
In the end I made a work around by removing the radio buttons and instead have interdependant combo boxes where the second combo box populates with a list dependant on the selection made in the first combo box.
Works out almost as well in this case

cheers

Steve