The one causing me the trouble is a form in which people enter data.
I need this form to return the correct information if an existing reference number is entered or allow new data to be entered if the reference number does not exist.
I have gone through a number of forums etc trying to get this working but it seems everytime I try one thing I get a new error message and I'm just going in circles!!
Please help!
I'm fairly new to VBA so go easy on me :)
Expand|Select|Wrap|Line Numbers
- Private Sub RefrenceNumber_BeforeUpdate(Cancel As Integer)
- Dim rs As DAO.Recordset
- Set rs = Me.RecordsetClone
- rs.FindFirst "[refrencenumber] = " & Me.RefrenceNumber
- Me.Bookmark = rs.Bookmark
- Set rs = Nothing
- End Sub