Why subform defaults to start new record??

[fedebrin]

Hello all,

I have a problem with a subform (Inside another form)

Automatically when loading it defaults to creating a new record causing me issues since it starts in a mandatory field... is there a way to stop this?

Take a look at the print-screen

thanks!

 

[pbaldy]

Are there existing records it should display? If so, what is the form's Data Entry property? What are the master/child links?

 

[fedebrin]

Hi, thanks for the quick response, yes there are existing records to display.

The Date Entry proerty is set to "No"

The record source is another table called "ACTIONS"
See print-screen

Thanks again

 

[pbaldy]

There are records meeting that filter as well? Are there master/child links specified in the subform control?

 

[fedebrin]

Hello, I deleted that filted as I don need it and it still does it.

Sorry, how do I check that regarding the master/child links?

thanks

 

[pbaldy]

They are properties of the subform control (the container that holds a subform).

 

[fedebrin]

yes, I think you got it Pat.

It is an event I have that updates the date in the field based on a subform of the actions.

The BeforeInsert even does not work for me because I need this macro to update after I change something on the subform of actions. I am looking to see which one could help me.