So I get the Invalid Use of Null, but am not familiar with fixing this. My code is thus:
Private Sub SaveBtn_Click()
Dim rs As Recordset, x As Integer
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Seals WHERE 1=0")
For x = Me.StartRange To Me.EndRange
rs.AddNew
rs!BoltNum = Me.Prefix & x
rs!BoxID = Me.Box_ID
rs!SealTypes = Me.Seal_Types
rs!SupplierLookup = Me.Supplier
rs!DateAdded = Me.Date_Added
rs!Site = Me.Site
rs.Update
Next
For x = Me.StartRange To Me.EndRange is highlighted as Invalid use of Null when these fields are unbound.
If I set their Control Source to the fields for them, then I end up with data in the fields StartRange and EndRange, and I dont need that.
I need a solution so that when I send the database to a colleague they can start with field 1 bland, and not have error 94 come up.
Help much appreciated.