Hi!
I have a form called 'Requests', which lists all requests made to our organisation, the PK being 'Record ID'.
I have another form called 'New Requests'. Users go into 'New Request' to add details of new requests made, the 'Record ID' (PK), is an autonumber which is geneated as soon as the user types on the form. Once a new request is added the 'Record ID' along with some basic details are added to the 'Requests form'. In some cases when a user is adding a new request he/she may only fill in some of the form information, to go back to at a later stage. Some of these 'incomplete' records are getting 'lost'. The 'Record ID' autonumber is increasing but the half complete records are disappearing.
Any ideas on how i can stop this from happening?
I have checked my code and cannot see any reason why these records should not be added to the main Requests form.
Please help!!!!!