p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB Databases Basics (http://p2p.wrox.com/forumdisplay.php?f=82)
-   -   URGENT Problems in Access 2000 (http://p2p.wrox.com/showthread.php?t=38267)

lizhaskin February 9th, 2006 11:50 AM

URGENT Problems in Access 2000
 
Hi there
Can someone give me some URGENT advice? I have written a database in Access 2003, which for some of the users is used in Access 2000. For these users, I have converted it to 2000 format, but am experiencing some problems. One situation in particular is a form (Bookings) which has a sub form (SalesInput) which in turn has another sub form (SalesSub) . On the Form SalesInput, I have a command button (Command34) which when clicked updates the data in the SalesSub form. In 2003, I use the following code very successfully.

Private Sub Command34_Click()
Dim strMsg As String

DoCmd.SetWarnings False

If IsNull(Me!InvNo) Then
    Label35.Visible = True

Else
    Label35.Visible = False
    DoCmd.GoToControl "SalesSub"
    DoCmd.OpenQuery "InvoiceAppend"
    DoCmd.Requery
End If
End Sub

However in 2000, it gives me an error on the “DoCmd.Requery” line. Is there a different syntax I should use for 2000?
Thanks to anyone who can help
Liz




mmcdonal February 10th, 2006 08:52 AM

Please post in Microsoft Office > Access VBA

I think the Requery needs a reference. Can you refer to the control in this code? If you are requerying the recordsource for one of your subfoms, I am not sure how you might do that.

A hardcore approach might be to freeze the screen, then close and reopen the whole form system while referring to the current PK on the main form.

HTH


mmcdonal


All times are GMT -4. The time now is 07:36 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.