Unbound combobox

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I cannot get synchronization between a combobox on a main form and various
subforms to work in an acceptable fashion.

Main Form = qryProgramAlpha2
SubForm = frmProgramInventoryCrosstabPremium 'There will be 5 subforms in
total
Field = ID 'field on which to synchronize
ComboBox = Name = Combo4, Row Source = SELECT qryProgramAlpha.ID,
qryProgramAlpha.Program FROM qryProgramAlpha; BoundColumn = 1; ControlSource
= ""

I've tried by macro, by VBA, by setting the criteria for the query, by
creating a invisble bound control to the ID field and synching subforms from
the bound control. The latter so far has produced the best results with the
notable expection that when first opening the form synchcronization has not
occured.

What've I've got now doesn't seem bulletproof.

Help is needed as I must demo today to an SVP.
 
It seems to me that all you need to do is make a call to
the procedure that populates the invisible text box from
somewhere like the Form Load event handler.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top