Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2017
    Posts
    1

    Unanswered: Open forms from select combobox value

    I want to know that any possible way that to open my forms open by select value from combobox
    Ex: i have 5 form for each department. When i select the department name from combobox tge time open correspondent form

  2. #2
    Join Date
    Jun 2017
    Posts
    17
    Provided Answers: 1
    Put the following into the "on Change" or "after update" events in your combobox:
    DoCmd.OpenReport "Exact Report Title", acViewPreview

    This page might help you more if you wanted to add other conditions.
    https://msdn.microsoft.com/VBA/Acces...-method-access

    For Example: DoCmd.OpenReport "Program Document", acViewPreview, , "RG =" & cmbRG

    So you might need something to read in the value of the position of a particular option in your combobox. Something like:
    DoCmd.OpenReport "Report", acViewPreview, , "ComboBoxValue =" & cmbComboBox.SelectedIndex
    Last edited by award73; 07-24-17 at 12:25.

Tags for this 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
  •