Is the month you enter, always less than a year from now?
>hi,
>thank you,
>i try to do this as under ,it works as add 31 days,
>but i need to replace dayname if the day name is friday,
>and i want to add month(2) feb..to month(12),take care if thedays for every month is 31 , 30 or 29 or 28 if month is=2
>

>IF MONTH(thisform.text2.Value)=01
>  FOR n=1 TO 31
>   APPEND BLANK
>  endfor
>endif
>

>>Hi Mohammed,
>>
>>I don't mean to be rude, but I don't understand what you want.
>>Do you want 31 blank records? If so, under what conditions.
>>Why do you mention Friday?
>>Can you give us a better explanation?
>>>hi all,
>>>
>>>i need help to insert 31 records at my table if month e.i =1,if day is friday insert(replace) at myfield rem friday
>>>as
>>>31 append blank
>>>thanks.