ClaraBarton
Registered User.
- Local time
- Today, 00:15
- Joined
- Oct 14, 2019
- Messages
- 479
When entering procedures or ingredients in a recipe, I have a default index that I can change manually after entering if I need to reorder the items.
This is the field's default value:
This works fine except that I get two 1's. So: 1 1 2 3 4 5 6. Such a simple thing. But not for me.
This is the field's default value:
Code:
=IIf(IsNull([RecipeIDFK]),Null,DCount("RecipeIDFK","qryIngredients","RecipeIDFK = " & [RecipeIDFK])+1)