Delete Record #Name?

[Jackson via AccessMonster.com]

Hi,

I've got a Main form with two subforms, 1 & 2. 1 is based on a query that is
joined to the underlying table that 2 is used to enter data for. I added a
button to Form 2 which deletes the current record from this table. Form 1
requeries On Current and after I've deleted a record and the Requery fires On
Current, all of the records are replaced with #Name?.

I've tried using Me.Refresh and Me.Requery to alleviate the problem, but the
only way to solve it is the close the form and then reopen it....

It seems there must be a way to code the requerying of the underlying data
but I'm not sure how to do it...any thoughts?

Thanks in advance.

 

[Guest]

Have you tried to run the requery in the function for the delete button. You
can try using something along the lines of Forms!mainform.requery

 

[jackwoodhead via AccessMonster.com]

I tried to have that after the delete record commands but I was requerying
the subform (1). Maybe I should try on the Main form though...I'll let you
know how it goes. Thx.

Have you tried to run the requery in the function for the delete button. You
can try using something along the lines of Forms!mainform.requery

Hi,

[quoted text clipped - 11 lines]

Thanks in advance.

 

[Jackson via AccessMonster.com]

hmm, same thing happens when I tried to requery the Main form...

I tried to have that after the delete record commands but I was requerying
the subform (1). Maybe I should try on the Main form though...I'll let you
know how it goes. Thx.

Have you tried to run the requery in the function for the delete button. You
can try using something along the lines of Forms!mainform.requery

[quoted text clipped - 4 lines]