Search results

  1. B

    combo boxes in subform fail to perform

    Are both combo's on the subform or one is on the main form and the other in the subform? I would also remove any spaces in the field names. That way you don't have to worry about quote marks.
  2. B

    IIF in Form fields

    =IIf([Forms]![frmInvoices]![VATRegistered]=-1),[TotalCost]*0.175,[TotalCost]) change to =IIf([Forms]![frmInvoices]![VATRegistered]=-1,[TotalCost]*0.175,[TotalCost])
  3. B

    Highlighting bookings

    Send a copy of your database to wavery1@bellsouth.net and I'll take a look. Rename it with and .zip extension. Otherwise my Outlook will block it.
  4. B

    Trapping error 3022 in order to automatically navigate to the pre-existing record

    You could use a DLookup in the AfterUpdate event of the ID field to see if the ID entered is all ready used before the rest of the form is filled. I assume you are getting the error when attempting to update the table.
  5. B

    Highlighting bookings

    Can you supply an example of your database?
Back
Top Bottom