Opening form from dbl click blank if no data in control

[dragongunner0351]

Hello all, I have an event that executes when the user double clicks a partNumber Control:

code:
DoCmd.OpenForm "Product Details", , , "[Products]![ID] = " & Me![Product ID]

This opens a details form for that partNumber. Is it possible for it to open a blank Product Details form if there is no partNumber in the parNumber control?

The end result I'm looking for is,
1. if there is a partNumber in the partNumber control then open the Product Details form to show the details on that partNumber.
2. if there is no partNumber, then open the Products Details form blank so that it can be added to the inventory list.

 

[agent0047]

I think this is what your wanting not a lot of code to look at but here goes:

If Me![Product ID]="" Then

DoCmd.OpenForm "Product Details"
Else
DoCmd.OpenForm "Product Details", , , "[Products]![ID] = " & Me![Product ID]

End If

 

[RivetHed]

I'd be careful about using "" in Access, try using IsNull instead or converting the Null value with Nz.

 

[TheAceMan1]

dragongunner0351 . . .

. . . or perhaps the following:

[blue]   Dim Cri As String
   
   If Trim(Me![Product ID] & "") = "" Then
      DoCmd.OpenForm "Product Details", , , , acFormAdd
   Else
      Cri = "[Products]![ID] = " & Me![Product ID]
      DoCmd.OpenForm "Product Details", , , Cri
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[dragongunner0351]

Thanks Ace worked like a charm

 

[agent0047]

Very true ;-)