Prevent new record on subform

[carmenv323]

I have a main form with a subform control.


when the main form is open the subform is always visible.

It's creating a new row in my table with no data, both forms have set Properties > Other > Cycle = Current Record

is there something I should add to the form load or on current? should I add code to delete empty records? if so, where?

Thank you

[Micron]

How do you know it's creating a new record? It's possible that one or more fields have a default value and what you're looking at is a new record that is a potential record but has not been saved. If you don't need the defaults (it is likely 0 in a number field - see table field in design view) remove them and see if it behaves any different. If there are no values at all, something could be creating a record and saving it with nulls or empty strings but I doubt it. You can open the vb editor and put a break on the open event of the subform and step through code (if you have any) to see what might be causing a new record, assuming that is really happening.

You could also copy, compact and zip your db and post here for analysis.

[carmenv323]

There are default fields in the form - a date is defaulted to the current date and the request by field is auto-populated as well. so that would make sense....

I've attached the database ... any suggestions?

[Micron]

Your tables are all linked - there is no data to work with nor can the table design be checked.. You would have to delete all the linked tables in your copy and then import them (Get External Data on ribbon) and import as tables. You would not need to do this to all of them, just what's needed for your issue. Or you'd have to post a copy of the be tables. The former approach would be better for us.

EDIT - forgot to say, be careful with linked back ends. If you copied the fe and be to another folder and deleted data from the be tables in that folder, you would not be deleting from the copy you created - you'd be deleting from the original because this fe copy is still connected to the original be. You'd be deleting production data. You must relink if you're going to play around like that.

[Gicu]

What is the name of the main form?

EDIT: had a chance to look at your db. I think the subform in question is frmRequests on CostEstimatingSystem main form. The subform has the DataEntry =Yes meaning it will open on a new record. Then in its Load event you start populating that new record by setting the RequestByPerson:

 Me.RequestByPerson.Value = ResolveCurrentUserName

Instead of populating the control like you do now try to set its default value property to the ResolveCurrentUserName custom function so you do not dirty the form.

Cheers,

[carmenv323]

What is the name of the main form?

EDIT: had a chance to look at your db. I think the subform in question is frmRequests on CostEstimatingSystem main form. The subform has the DataEntry =Yes meaning it will open on a new record. Then in its Load event you start populating that new record by setting the RequestByPerson:

 Me.RequestByPerson.Value = ResolveCurrentUserName

Instead of populating the control like you do now try to set its default value property to the ResolveCurrentUserName custom function so you do not dirty the form.

Cheers,

I had those fields already with the default values so I removed from the FormLoad but it still created a new record.

[Gicu]

As micron said it is hard to debug a linked app, try to import the tables needed for those forms (main\sub) to open properly, compact it, zip it and uploaded here.

Cheers,