Subform not displaying properly

F

funguy_007

Good morning everyone,

I had a simple order database setup exactly like Northwinds in Access
2003. Everything works fine. I decided that I wanted to add a
command button to my main form. This command button opens a form that
is coded using the "find as you type modules" from Allen Browne's web
site.

When I double click on the item that I want to add to the order - I
want it to add it to the subform on the main form so I can check and
make sure I have everything correct before processing the invoice.
Everything works (ie. all information is going to correct tables) The
problem is that the information is not showing up on the subform. I
see it going on then it disappears.

I am using the following code in the double click procedure.

Private Sub EquipmentName_DblClick(Cancel As Integer)
'Adds equipment to the subform
Forms!frmLoan!frmLoanSubForm!EquipmentID = Me!EquipmentID
'sets focus to main form
Forms!frmLoan.SetFocus
'performs refresh
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
'sets focus back to Equipment search form
Forms!frmEquipmentSearch.SetFocus

End Sub

It had been suggested that I need to requery the subform but I am
unable to get that to work properly.

Any help is appreciated.

derek
 
Top