Prevent changes to First record on subform

[lizray]

I Open a subform and do not want users to change the first record. On the "Current" event I have the following:
If Me.recordset.Bof=true then
me.allowedits=false
else
me.allowedits = true
End if
But it doesnt do anything...Any Ideas ?

 

[TheAceMan1]

How are ya lizray . . .

Try:

[blue]   Me.AllowEdits = Not (Me.CurrentRecord = 1)[/blue]

[blue]Your Thoughts? . . .[/blue]

BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[lizray]

Thanks once again It does the job perfectly...you really are the Aceman

 

[TheAceMan1]

lizray . . .

Don't know why I used [blue]Not[/blue] in the code. You can get rid of it with:

[blue]   Me.AllowEdits = (Me.CurrentRecord <> 1)[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]