control source

[shrive22]

is there anyway to change the control source of a text box based upon if a record is for a company or an individual?


thanks

 

[SydneyGeek]

Not sure, but you can get a similar result by having 2 textboxes overlaid, one with the Company controlsource and another with the Individual controlsource. When you update the control indicating Company or Individual, toggle the Visible property so that the appropriate textbox is displayed.

eg: [Control1] allows you to choose Company or Individual
In the AfterUpdate event for this control, this code ---

If [Control1]="Company" then
  [Text1].Visible=True
  [Text2].Visible=False
Else
  [Text1].Visible=False
  [Text2].Visible=True
End If

Should do the trick. Note: you can determine which textbox displays when you browse records, by inserting similar code in the OnCurrent event of the form. Adjust control names to suit.

HTH

Denis