Access displaying records

[PrettyMess]

Hi,

I have two fields in my table if both of these fields values are "0" I don't want the record to show in my form but if it happens to be any other combination I do want it to show.

I'm figuring it needs to be some sort of If statement but I'm not sure how to get this to reflect in my form.

Any help would be greatly appreciated.

I think it may need to look something like this:

        Private Sub TypeList_AfterUpdate()
        If (OutboundReservations.Value And InboundReservations.Value = "0") Then Me.showrecord = False
        Else
        Me.showrecord = True
        End Sub
        End If

Thanks

 

[Micron]

If the form is based on a query, a calculated field Res:[OutboundReservations]<>0 And [InboundReservations]<>0 with criteria <>0 will prevent the record - no code needed, other than whatever you're already using to refresh/requery the form. Generally speaking, forms are more flexible if they're based on queries as opposed to tables.
If you must do it in code, your first problem is that this "OutboundReservations.Value And InboundReservations.Value" makes no sense to Access - it is not read/interpreted the way you are doing so. It has to be more like OutboundReservations.Value = 0 And InboundReservations.Value = 0
To not show the record would require a requery of the form (or application/re-application of a filter). This is a bit harder to do if based on a table. Now you have to create/modify and apply a filter. If you create a named filter (filter query), you might as well base the form on a query.