start with a new record

[REDaughdril]

I have a subform that I want to start with a new record each time. How do I do that. I know I'll kick myself for not knowing or figuring it out. Thanks

 

[Jack Cowley]

Set the forms Data Entry property to Yes.

hth,
Jack

 

[Pangloss14]

Hi,

In the same vein of question, if I have a subform whose data is linked to the data shown in the main form (which is selected via a combo/list box), how can I make it show a new record each time I select something from the combo/list box.

Currently, if I select a record in the main form from the combo/list box, the last record in the subform always shows up. I would guess that the answer is simple, but I haven't found it yet. . Thanks in advance.

John

 

[Jack Cowley]

In the combo's After Update, along with the other code add this line, changeing the control name to your controls name:

Me.SubFormControlName.Form.DataEntry = True

I hope this is what you are after. Remember that you will only see a new record if you make a selection from the combo box...

Jack

 

[Pangloss14]

Hi,

Yes that is what I was looking for. Thanks. I'm' curious though as to why it didn't work by simply setting that property for the subform in question when in the design view.

Thanks again.

John