No Value error

[dynamictiger]

I have a form which is balnk to start up. On this form I have various command buttons. I thought to prevent errors I would enable and disable according to the record on the form.

On start up the form has no record. So when I code if Me.ID>0 then I get an error saying Me.ID has no value.

I have never come across this before and am not sure of what to use to handle it?

 

[Mile-O]

Is ID bound to an autonumber field in an empty table?

 

[dynamictiger]

At this point in time that would be correct. Although it is a query not a table.

 

[Rich]

If IsNumeric(MyField) Then
etc

 

[dynamictiger]

Thank you. That solved that problem. So simple just one of the combinations I have never used.