D
Dan McClelland
Using Access XP and SQL Server 2000.
Have a form whose recordsource is either an SQL statement
or a stored procedure (more than one table). Unique table
and Resync command properties are set. Form has
AllowAdditions set to false, but New Record button sets it
to true through VBA code and I'm able to begin adding a
record.
Upon closing the form, if I've skipped any of the required
fields, the form closes with no warning and the new record
is not inserted. Why? My users need a warning.
Have a form whose recordsource is either an SQL statement
or a stored procedure (more than one table). Unique table
and Resync command properties are set. Form has
AllowAdditions set to false, but New Record button sets it
to true through VBA code and I'm able to begin adding a
record.
Upon closing the form, if I've skipped any of the required
fields, the form closes with no warning and the new record
is not inserted. Why? My users need a warning.