Results 1 to 2 of 2

Thread: Unlinked Subforms

  1. Jul 13th, 2006, 10:20 PM #1
    swoozie
    swoozie is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Washington DC
    Posts
    330

    Unlinked Subforms

    I am using Access 2003.

    I have a form with 2 combo boxes. These are to choose criteria to populate a subform.

    The forms are not linked.

    I want to assign a different Record source property to the subform depending on the values provided in the combo boxes. The issue I am having is locating the correct syntax for the record source property to be updated.

    I have tried

    Forms!frmUpdateIssueDueDate!sfrmUpdateIssueDueDate.RecordSource
    Me.sfrmUpdateIssueDueDate.RecordSource
    Forms!sfrmUpdateIssueDueDate.RecordSource

    an a few other combinations and they are not working, any suggestions?
    Swoozie
    Somedays you just should not get out of bed.
    Reply With Quote Reply With Quote
  2. Jul 17th, 2006, 03:51 PM #2
    swoozie
    swoozie is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Washington DC
    Posts
    330

    Re: Unlinked Subforms

    I have also tried

    Forms!frmUpdateIssueDueDate!sfrmUpdateIssueDueDate!RecordSource = GetRecordSource()
    Swoozie
    Somedays you just should not get out of bed.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width