New record not being added to main form

[hmcquade]

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!!!!!

[RuralGuy]

What are you doing to update the "Requests" RecordSource from the "New Requests" form?

[hmcquade]

Both forms are looking at the same table. The relationships were created at table level and forced to cascade through.

[RuralGuy]

Are both forms open at the same time? Have you turned off Warnings? The forms should be using queries of the table rather than the tables directly.

[hmcquade]

No both forms are not open at the same time. I dont think i have turned off warnings, i dont know how to do that even!

The 'New Request' form is based on the table. I built the form from the table. Request form is just a seperate form that looks at the same table.

If users type in a significant amount of information, i.e. populate more fields, the record adds itself to the request list no problem. I dont think its a relationship problem here. Its as if users have to reach a certain field before the record will count, problem is i dont know where that field is? Or what function makes it do this.

[RuralGuy]

Access *will* save any "Dirty" records regardless of how you exit the form unless you take extraordinary steps to prevent it. Are your tables and forms in the same db or have you split the db?

[hmcquade]

no they are in the same db?

[RuralGuy]

Are all of the controls on the 'New Requests' form bound to fields in the underlying table? Can you duplicate the problem reliably and consistantly?

[hmcquade]

yes, all the fields are bound to the table.

I am just going through now, populating a field at a time then exiting the form, to see at which field it will add the record

[hmcquade]

ok, ive done some testing, and i think i have rectified the problem.
I had set fields to 'Required', in the table itself. once i changed this, the records were being added even though these fields were not populated.

Thank you everyone for all your help and suggestions!!!

[RuralGuy]

It should add the record with only one bound control altered. If that is not the case, can you zip your db and post it?