Default to new record after combo box select.

[accessmatt]

Hello,

I have a Form with fields to enter what's needed to create a record. On the same Form Page, I have a subform connected to a pass through query from a combobox. The issue is that the first time I select from my combobox, the last record in my database appears in the form fields. How can I fix that so that Access defaults to a new record after I select the choice from my combobox? Thanks,

[June7]

If you want a new record, why are you selecting something from combobox? What is the combobox choice for - to filter main form?

[accessmatt]

Hi June7, the Combobox is used to filter a query which is being displayed in the Form. It's essentially output from the database which would be important to know for someone entering info into the fields/database.

[June7]

I don't use dynamic parameterized queries. If that's want you are doing, then code needs to requery the form after selection.

[accessmatt]

June7, why don't you use dynamic parameterized queries?

[June7]

Too often when I am developing I open query to look at data and parameter input popups are not wanted and annoying.

I use code to apply filter criteria to forms and reports.

[accessmatt]

June7, ok I actually meant to say that I was using filter criteria. There are no Dynamic Criteria Pop Ups. I agree, those are super-annoying.

[June7]

Still not sure what you need to happen.

Combobox is on main form and it is used to filter main form? Then you want the subform to have focus on its new record row?

[accessmatt]

June7,

The Combobox is on a subform. I'm using this to open to a new entry when the form is opened:

Private Sub Form_Load()DoCmd.GoToRecord , , acNewRec
End Sub

and I'm using this on my combobox:

Private Sub Combo71_AfterUpdate()
Me.Requery
End Sub

Everything works fine except for the first time I use the combo box. In that case, the last record in my database shows up. How can I refresh/show a blank record in all instances after using the combobox.

Thanks!

[June7]

What is the combobox for? Are you saving the selection into subform record? Is this this only data entry? If you want to move to new record (blank) row of the subform then have code in the combobox AfterUpdate event to do that, just as you have in the main form Load event.

I don't see a need for the Me.Requery.

[accessmatt]

June7, this is exactly what I need help with. Could you provide the code? (I'm using the combobox to filter a query, which is being displayed as a sub-form)

If you want to move to new record (blank) row of the subform then have code in the combobox AfterUpdate event to do that, just as you have in the main form Load event.

[accessmatt]

June7,

Someone else told me to try setting DataEntry mode on the form to True and that solved my problem. No need to most the code for me. Thanks as usual though!