Need some help with Access please

[Raistlin]

Ok,

I have an access table:

tblItemDetails

And I need to add some records to it programmatically.

The table has the following fields:

strItemNumber
strItemDescription

I have a form (frmEnterNumbers) with two text boxes on it:

txtStartNumber
txtEndNumber

What I want to do is this:

Click a button on the form.
Access opens the table and adds a new record where strItemNumber is equal to txtStartNumber.
Access moves from this record to the next new record and adds a record where strItemNumber is equal to txtStartNumber + 1.

The other field strDescription will be left blank and will be filled in by the user as and when they need to.
The idea being that I will end up with new records in the table ranging from txtStartNumber to txtEndNumber.

[Raistlin]

's ok, got it sorted now.

Racked my brains for a bit until I remembered how I had done it 18 months ago when I had a similar project.

Cheers anyway

[Raistlin]

Ok, new problem.

Have two text boxes:

txtNumberOne
txtNumberTwo

When txtNumberTwo loses focus I want some VBA script to check that the number in txtNumberTwo is greater than the number in txtNumberOne.

If it isn't I would like some sort of warning to pop up, then when the user clicks on OK the focus should return to txtNumberTwo and the number in that field should be deleted.

Please could somebody help me with this, I know it should be simple but my brain's well and truely addled today

[Nemesis]

Private Sub txtNumbertwo_LostFocus()
Dim value1, value2
value1 = txtNumberone.Value
value2 = txtNumbertwo.Value
If value2 > value1 Then
MsgBox "Value 2 larger than Value1", vbOKOnly, "ERROR"
txtNumbertwo.Value = 0
txtNumbertwo.SetFocus
End If

End Sub

[Raistlin]

Thanks Nem