Popup form to enter data from a subform

[jenniebentham]

Hi, I have a 3 table DB. Staff, Courses and Training Details (link table)

I have a main form of Staff and a Subform that allows me to add a record to
the Training Details table by selecting a Course and then adding a date of
attendance.

My problem is that some of the staff have been on so many courses that the
New Record line is not visible at the bottom of the subform (continuous form
used).

What I would like to do is to have the subform AllowAdditions=false and then
click a button to Add a new training record via a form or box to pop-up to
just add in the new details in the same format as the existing subform. I
have tried just getting a button to open a duplicate of the subform, but it
causes problems with the exisitng tables being locked as they are open in the
main form.

Any ideas?

 

[rkresnadi]

The easiest way to do this is set the subform property to allow scroll bar.
Then the user can just scroll it to bottom of his list.

Let me know if this does not work or if you prefer a more complicated
solution.

Restu KResnadi