View Single Post
  #1 (permalink)  
Old February 9th, 2006, 11:50 AM
lizhaskin lizhaskin is offline
Authorized User
 
Join Date: Apr 2004
Location: Cape Town, , South Africa.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lizhaskin
Default 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



Reply With Quote