User Profile

Collapse

Profile Sidebar

Collapse
hawg1
hawg1
Last Activity: Sep 24 '07, 07:47 PM
Joined: Sep 16 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hawg1
    started a topic populate subform using combobox
    in Access

    populate subform using combobox

    Hi,

    Having problems getting combo box on main form to populate subform after selection.

    Combo box itself works fine (used wizard to create it). Subform comes up with blank fields. Any suggestions? I know this is a simple matter, but it eludes me.

    Hawg1
    See more | Go to post
    • hawg1
      replied to Form Appearance
      in Access
      PEB,

      Thanks for the help. I got her working. I finally decided to just delete the subform and install a new one on the main form and everything is working....
      See more | Go to post

        Leave a comment:

      • hawg1
        replied to Form Appearance
        in Access
        PEB,

        I'm probably losing it as I can't seem to get it to work. I keep getting error messages that state 'can't fine field...'

        So I figured I would start over some what. I created a new blank form called hide test in design view. I then draged the form PersAction_Pers Data (contains several text/combo boxes) onto the detail section of the form hide test. Save and open the form and the subform is present.
        ...
        See more | Go to post

          Leave a comment:

        • hawg1
          replied to Form Appearance
          in Access
          PEB,

          Thanks for the code suggestion. I understand that the name of the subform goes into the [SubForm] part of the code.

          I'm unsure what should go into the [F1] or [F2] part. Could you please elaborate for me? I'm new to VBA and am slowly learning all of the terminology.

          Thanks for your help

          Hawg1
          See more | Go to post

            Leave a comment:

          • hawg1
            started a topic Form Appearance
            in Access

            Form Appearance

            I would like to have the area on my form, where a subform is located, to be an empty box with a border when the main form is initially opened. Then when user clicks on a button, the actual fields comprising the subform are visible, ready for the user to enter the required data.

            The main form is an initial entry point in which the user can select four options (Insert new data, delete existing data, query exisiting data, and save...
            See more | Go to post
            • hawg1
              replied to Form/Subform help
              in Access
              PEB,

              Thanks for the info on the coding. Will give it a try!
              See more | Go to post

                Leave a comment:

              • hawg1
                started a topic Form/Subform help
                in Access

                Form/Subform help

                I'm fairly new to Access and need help with form/subform. I've seen another access database in which a main form allowed the user to enter school class specific information shuch as start date, title and class size. Once they tabbed out of the class size box, a subform appeared to allow input of student data. For example, if class size of 4 was entered, subform would appear with four data input lines, one for each student.
                I can generate...
                See more | Go to post
                No activity results to display
                Show More
                Working...