Force A New Record

[ddrew]

I have a continuous form it has a field (DateStart) and a field (DateStartCarryOver). There is an event on (DateStart) for the (DateStart.Value) to be passed to a new record in (DateStartCarryOver).

My probem is that the new record dosent get saved (i.e. it dosent get an ID so a record isnt created. How can I create that record once the data has bee pased to it?

 

[Mihail]

By putting a default value in the control before saving the record.

 

[ddrew]

By putting a default value in the control before saving the record.

Thanks, I tried this but t dosent seem to work. I'm clearly doing something wrong.

There are no records in it right now, but if you open the form and put a date into the (Date of Birth) at the top of the page, then start a couple of records, you will see the startdate carry over into the next record, but it dosent create a record i.e. no ID.

 

[Mihail]

This will help you to solve the issue (for sure).
Be patient and read the entire thread: there are 2 solutions.

Be aware: Your approach is based on a very bad practice !!!!
Never store in DB something that you can calculate.
So, remove all calculated fields from your table then base the form on this table.
The query is no more necessary.

Good luck !