Form Design

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Dear whatever genius can help me today.

I have a form from a table for entering course information
as follows:

Course ID primary key autonumber
Course Name
Course Date

I have it set up on a tabular form and when it opens it
shows this:

Course id course name Course Date Course Venue (I
want a button here that will allow me to click and book
someone into this course.)

I have done this as follows - Button wizard Open a booking
form that I have created from the same table with the
following fields.

Course ID
Course Name
Course Date
Course Venue
Staff Number

When I click the command button and am brought to this
form, I want the course info to stay there and just the
staff number to be blank so I can type the staff number in
and then someway add this staff member to a table and that
way they have been booked on the course?????

I have tried everything but I have tied myself up in knots.

Maybe my underlying tables are wrong.

Please help me!!!

Ann - (Ireland)
 
Thanks a million Jackie
Success!!!

Ann
-----Original Message-----
Ann,

First of all, I would not recommend repeating the Course
Click to expand...
Name and Course Date in the table containing the student
info (I will call it tblCourseAttend). The Course ID in
the main table should be linked (one to many) to the
tblCourseAttend Course ID. Course ID and Staff Number
should be the key fields for tblCourseAttend.
Then, on your form to enter the attendees, have the field
Click to expand...
Course ID default value refer back to the orginal form.
For example: =Forms![frmCourse]![CourseID] (use your
expression builder on the default property for correct
syntax). Have the rest of your fields (excluding Course
Name and Course Date), unless you would like those to show
in the form header (which is a different issue).
Create a new button to open your second form and be sure
Click to expand...
to pick "select records..." and have the Course ID the
link.
Now you should be able to open your new form, only see
Click to expand...
those records for the Course ID and be able to add
attendees.
 
Back
Top