New Record Question

[Phil_L]

In a tabulated form that i have created, i'd like to only add another record only when a yes/no field in the last record is set to true

Is there anyway of doing this?

Any help is apreciated

Cheers,

Phil

 

[maxmangion]

try something like this:

If Me.FieldName = True Then
Me.AllowAdditions = True
Else
Me.AllowAdditions = False
End If

Replace FieldName with the name of your yes/no field.

 

[Phil_L]

which event should i put this code under?

 

[maxmangion]

if initially you're setting the allowadditions to false, you can use the afterupdate event of your yes/no field.

 

[Phil_L]

If I initially set allowadditions to false then there is no initial record on the form, therefore no tick box to tick. If I initially set allowadditions to true then as soon as i enter information in the record a new record appears. I dont want this to appear until i tick the box at the end.