Showing a 'New' Button

[CarlRostron]

I know there is a way to show a conditional 'New' field button or something similar to that in the screenshot on the next available table record.

=IIf(IsNull([LinkerID]),"(Add)","Remove")

I have tried to copy the method behind this from another of my tables which works but it is not working this time around. It looks to me like the next available record is not being displayed in my datasheet.

Please help.

 

[missinglinq]

In order to allow both Numeric and Alpha characters to be entered, as ClientID does, in the working example, it has to be defined as a Text Datatype.

InvoiceID, on the other hand, is apparently defined as either a Numbers Datatype or, more likely, as an Autonumber Datatype, neither of which will allow the entering of Alpha characters, as is necessary for "Add" or "Remove."

Linq ;0)>