Just to add to what m_saleem_khan said below, you may need to add a criteria to the statement that opens the second form like:
DoCmd.OpenForm "SecondForm", , , "ProjectID = '" & Me.ProjectID & "'" This will ensure that only the records that are for the selected project are displayed in the second form. Notice the single quotation marks that must be used just before and after ProjectID if the ProjectID is a string otherwise they should be left out. HTH Liveson ----- Original Message ----- From: m_saleem_khan To: [email protected] Sent: Saturday, 03 May, 2008 11:43 AM Subject: [ms_access] Re: Need Help with Access In the first Form place a Button (Go, Next, OK, Proceed whatever) and in its event procedure: DoCmd.OpenForm "SecondForm" for transfering control to your second Form from the first. --- In [email protected], "Arman, Shirin & Niki Hamraei" <[EMAIL PROTECTED]> wrote: > > I am good at Access, but not good at coding at all. In fact I don't code at all. All of my stuff in Access is driven off of what Access produces. > > What I need to do is to create a form that will feed another form. So I need a small form, in that form I have 4 fields. I pick the person, the projects they are assigned and couple other field and hit GO or NEXT or whatever and another form pops up with 50 or so fields, detailing the project I picked. Does anyone know how I can do this? > Thanks. > > [EMAIL PROTECTED] [Non-text portions of this message have been removed]
