Linking 2 forms

[Shaldaman]

I have 2 forms - 'Existing Instructor' and 'New Course' which are
linked. The first form has the following fields - InstructorID,
Instructor First Name, Instructor Lase Name and Department, all of
which get populated when the form loads - the information for all the
fields is retrieved from an 'Instructor' table. The 'New Course' form
has 3 fields - InstructorID, CourseID, Course Name. If a user on the
'Existing Instructor' form clicks a button 'Add New Course'(named
Command11), it should open the 'New Course' form, displaying the
corresponding InstructorID but the other 2 fields should remain blank.
When the user enters information for CourseID & Course Name, and click
a button 'Add Course' on the form, the CourseID & Course Name are
inserted into another table 'Course'. The 'Instructor' table has a
one-to-many relationship with the 'Course' table.

Here's my problem. I have an idea of how to synchronize 2 forms' data
but I don't know how to fill only the 'InstructorID' field on the 'New
Course' form and leave all other fields blank and ready for data entry.
It's important that the InstructorID value in this form matches the
InstructorID value of the previous form 'Existing Instructor'. Right
now, when i click on the 'Add New Course' button on the 'Existing
Instructor' form, it opens the
'New Course' form with all the fields blank. I can manually enter the
values for InstructorID, CourseID & Course Name, and click button 'Add
Course' to add the data to the 'Course' table but I want the
'InstructorID' to be generated automatically. Please help.

Shal

[Salad]

Shaldaman wrote:

I have 2 forms - 'Existing Instructor' and 'New Course' which are
linked. The first form has the following fields - InstructorID,
Instructor First Name, Instructor Lase Name and Department, all of
which get populated when the form loads - the information for all the
fields is retrieved from an 'Instructor' table. The 'New Course' form
has 3 fields - InstructorID, CourseID, Course Name. If a user on the
'Existing Instructor' form clicks a button 'Add New Course'(named
Command11), it should open the 'New Course' form, displaying the
corresponding InstructorID but the other 2 fields should remain blank.
When the user enters information for CourseID & Course Name, and click
a button 'Add Course' on the form, the CourseID & Course Name are
inserted into another table 'Course'. The 'Instructor' table has a
one-to-many relationship with the 'Course' table.

Here's my problem. I have an idea of how to synchronize 2 forms' data
but I don't know how to fill only the 'InstructorID' field on the 'New
Course' form and leave all other fields blank and ready for data entry.
It's important that the InstructorID value in this form matches the
InstructorID value of the previous form 'Existing Instructor'. Right
now, when i click on the 'Add New Course' button on the 'Existing
Instructor' form, it opens the
'New Course' form with all the fields blank. I can manually enter the
values for InstructorID, CourseID & Course Name, and click button 'Add
Course' to add the data to the 'Course' table but I want the
'InstructorID' to be generated automatically. Please help.

Shal

I'm not sure if this answers the question but you can pass an argument
to the next form
DoCmd.OpenForm "someform", , , , , , "ArgumentToPass"
or you could fill it in after the form
DoCmd.OpenForm "someform"
Forms!SomeForm!InstructorID = 123
if the form you open is not modal.

[Shaldaman]

That was a really good idea - I went ahead and set the subform's
OnCurrent property to show the same InstructorID as the main form using
your idea. It works but my only problem is that the other fields are
getting populated from the Course table. I want those fields to be
associated with the Course table because on clicking the Add Course
button, the values from those should get inserted into the table(i.e. i
don't want the fields to be unbound or i won't be able to insert values
into the table). I've got that working(the insertion into the table
part)but i don't want the values from the Course table to be pulled up
each time the form opens. Otherwise, users will overwrite exisiting
values.

If a user with InstructorID value 72 opens the New Course form, this is
how it should look:
InstructorID = 72 (Only this field should be filled)
CourseID = ---------
Course Name = -----------

What do I do? By the way, thanks for the earlier tip.

[Shaldaman]

I think I might have figured it out. I passed blank values for the
other fields:

Private Sub Form_Current()
Me!InstructorID = Forms![Existing Instructor]!InstructorID
Me!CourseID = ""
Me!CourseName = ""
End Sub

This seems to work. Thanks.

[Salad]

Shaldaman wrote:

I think I might have figured it out. I passed blank values for the
other fields:

Private Sub Form_Current()
Me!InstructorID = Forms![Existing Instructor]!InstructorID
Me!CourseID = ""
Me!CourseName = ""
End Sub

This seems to work. Thanks.

In the Docmd.OpenForm you can also open it so it is in Add mode
docmd.OpenForm "x",,,,acFormAdd
so you could open it and then populate the InstructorID

[Shaldaman]

I didn't think about that. Let me give that a shot. I have another
quick question - I'd done this before but for some reason I can't
remember how to do it. How do I make the InstructorID text field
non-editable? Thanks again...

[Salad]

Shaldaman wrote:

I didn't think about that. Let me give that a shot. I have another
quick question - I'd done this before but for some reason I can't
remember how to do it. How do I make the InstructorID text field
non-editable? Thanks again...

Well, I'd open the properties form and set locked to True