-----Original Message-----
Create an option group on the main form with three options: Option1 uses Field1,
Option2 uses Field2, Option3 uses Field3. Put the following code in the
AfterUpdate event of the option group:
Select Case Me!NameOfoptionGroup
Case 1
Me!NameOfSubformControl.LinkChild = "Field1"
Case 2
Me!NameOfSubformControl.LinkChild = "Field2"
Case 3
Me!NameOfSubformControl.LinkChild = "Field3"
End Select
Me!NameOfSubformControl.Form.Requery 'Not sure if you need this. Try without
first.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
.