link child field in subform?

[adriany]

So far, it works like this
Form with Calendar picker
subform has
Link master fields = calendar date(calendar picker)
Link child field = field1
view only the matching date from cal picker on field1

Want solution like this. same as above but with option
button to choose Line child field = field1 or field2 or
field3. so, i can view on date that are
field1 or field2 or field3

All fields are dates on subforms, I like to choose date
from cal picker then choose option button 1,2,3.

thanks

 

[Graham Mandeno]

Hi Adriany

You should be able to change the LinkChildFields property on the fly:
Me.[Subform control name].Form.LinkChildFields = "Field2"

I suggest you place an unbound combo box or option group on the main form to
select the date field to link, and use its AfterUpdate event to set the
required LinkChildFields property setting.

 

[adriany]

thanks that worked!
onemore question about subform!

how do printing only what users sees on subform?

i have link subform filter by linkchild on dates,
anyway to print only what appear from subform?

adrian

-----Original Message-----
Hi Adriany

You should be able to change the LinkChildFields property

Me.[Subform control name].Form.LinkChildFields = "Field2"

I suggest you place an unbound combo box or option group on the main form to
select the date field to link, and use its AfterUpdate event to set the
required LinkChildFields property setting.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

So far, it works like this
Form with Calendar picker
subform has
Link master fields = calendar date(calendar picker)
Link child field = field1
view only the matching date from cal picker on field1

Want solution like this. same as above but with option
button to choose Line child field = field1 or field2 or
field3. so, i can view on date that are
field1 or field2 or field3

All fields are dates on subforms, I like to choose date
from cal picker then choose option button 1,2,3.

thanks

.

 

[Graham Mandeno]

Hi Adrian

Don't try to print the subform. Instead, create a report to print the
details you want, and filter it by date:

DoCmd.OpenReport "MyReport", , , "[DateField]=" _
& Format(Me.DateControl, "\#mm/dd/yyyy\#")

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

thanks that worked!
onemore question about subform!

how do printing only what users sees on subform?

i have link subform filter by linkchild on dates,
anyway to print only what appear from subform?

adrian

-----Original Message-----
Hi Adriany

You should be able to change the LinkChildFields property

Me.[Subform control name].Form.LinkChildFields = "Field2"

I suggest you place an unbound combo box or option group on the main form to
select the date field to link, and use its AfterUpdate event to set the
required LinkChildFields property setting.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

So far, it works like this
Form with Calendar picker
subform has
Link master fields = calendar date(calendar picker)
Link child field = field1
view only the matching date from cal picker on field1

Want solution like this. same as above but with option
button to choose Line child field = field1 or field2 or
field3. so, i can view on date that are
field1 or field2 or field3

All fields are dates on subforms, I like to choose date
from cal picker then choose option button 1,2,3.

thanks

.