Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    'On Open' Property

    I have posted the same question on the general, but I think this board would be more appropriate. I currently have many sub forms inside a form. All the tables linked to the form has A primary key. I would like upon opening of the subforms, the selected record in a combo box in a previous form be fired off. I have a global variable saved from the combo box. How can I have the sub forms open with that global variable. Do I do this in the On open prop. And if so, How can i get that particular record to populate. Thanks guys


  2. #2
    Join Date
    Dec 2005


    A is the global varilabe
    and I have the following in whatever even i wish. In my big form, the subforms are just tabs. The users can just click through the forms. This does pull up the correct record, but of course it opens the form instead of just remaing in its tabbing state. Is there a way to keep it in the origingal form instead of opening it in a new form? Thanks so much

    S = "[ID]=" & A
    MsgBox ("test2") & S
    DoCmd.OpenForm "Pricing subform", , , S

    a stressed out vb learning cat

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can not open File already in use.
    By Wrangler in forum Access
    Replies: 1
    Last Post: 03-04-2009, 09:50 PM
  2. Replies: 1
    Last Post: 08-10-2008, 01:09 AM
  3. Form will not open
    By dserbanescu in forum Forms
    Replies: 0
    Last Post: 01-09-2008, 09:48 AM
  4. Replies: 3
    Last Post: 02-02-2006, 07:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums