Subform controls not clearing when form advanced

[BobJacksonNCI]

Hi!

I'm using Access 2000 with SQL 7 to create an ADP.

Have 2 SQL tables related in a database diagram.

Created form + subform to enter/retrieve records from the tables. Works fine when entering records where none exist and for editing existing records. (For user friendliness, I want them to be able to add/edit/view using the same form/subform.)

BUT, when advanced to a new record on the form, the subform still shows the records from the previous form.

I have Link Master Fields and Link Child Fields properties set. Have On Current event used to determine if the user is working on a new record or viewing/editing an existing record. Tried adding subform.dataentry = true, Access didn't like that.

Assistance would be GREATLY appreciated!

 

[BobJacksonNCI]

Uh,

There's a chance I don't know what I'm doing...

(Be gentle, please)

Commenting out the code below which in in the
form's On Current event may have corrected the problem.

Dim rs As Object
Set rs = Me.Recordset.Clone