Reply to thread

Message: [QUOTE="Ken Snell [MVP], post: 2565157"] The popup form would be essentially the same as the current form (would have same layout and same recordsource for main form and for its subform), with two exceptions: 1) set the main form's Data Entry property to No and AllowAdditions property to No. 2) filter the form (using the WhereCondition argument of the DoCmd.OpenForm step, which also would open the popup form in Dialog mode) to just the main form record that already exists (I don't recall the specifics off the top of my head, but I recall that the "primary key" for the main form is the EmpID, CorrespondID (?), and WorkDate(?). This will allow use of the existing record, will prevent the creation of new main form record and avoids having to change the properties back and forth of the current form. -- Ken Snell <MS ACCESS MVP> [/QUOTE]