Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    54

    Unanswered: Is it possible to make changes apply throughout?

    I have a table which has listboxes.

    I have made a query, form and report from it.

    I want to change the listboxes in the table from listboxes to combo boxes, and make this change apply throughout the associated queries, forms and reports.

    Is there an easy way to do this instead of recopying everything in the forms and reports or creating new ones? Such as changing the properties?

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183

    Is it possible to make changes apply throughout?

    What I found out from my past experience is that we need some manual intervention to reflect the changes across other objects.

    Immediately after changing the name of a Table if we open the Query with the old table name it changes the name in the Query automatically. The opening action is required to effect that change.

    If we modify a Table field to add a Combobox (Lookup) then on the Form/Report we must remove the earlier Field control and drag the Field again from the Field list to reflect the Combobox change on the Form.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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