Open new form vs. record select

[graccess]

I have a form that will be used to enter new records and edit existing ones. Presently, when I click on a filtered subform that displays my records, it loads the form containing the selected record, no problem there. But if I select the form separately to begin adding new records, it loads up either that last viewed record or the first record in my database. I can't seem to figure out where to put the code or event procedure to fix my problem to automatically determine where I'm adding a new record or intentionally adding the selected record. thanks in advance.

[June7]

How are you opening the form 'separately' for new record entry?

[graccess]

from a switchboard. another odd thing about my forms after they load from the switchboard is the queries don't function correctly after they've been loaded. when I make a selection from a combo box field within that form, nothing populates. when i launch the form separately from the form list in my navigation bar, it all works fine.

[June7]

Is this a switchboard created by the old switchboard wizard or just a form with buttons and code?

Doubt I will be able to identify cause and fix from your narrative. This requires getting intimate with design and code.

[graccess]

This is the old switchboard wizard but i think I may have found a workaround that fits. thanks again.

[ipisors]

I recommend re-constructing the database without a switchboard, custom code the necessary events (etc). This will have much more potential as an application in the long run.

"Presently, when I click on a filtered subform that displays my records, it loads the form containing the selected record, no problem there"
How does it do that? You'll need to view the code that causes that to happen. Unfortunately, switchboard-generated code can be a very, very non-intuitive, and generally ugly thing to wade around in. Put on your waist-high swamp boots, gear up for a scavenger hunt, and determine in the future to move on past switchboards into custom coded forms!

[June7]

Amen! This is why the Switchboard wizard is not available up front in 2010 (or did that happen in 2007). Finding it takes some effort.

[ipisors]

Amen! This is why the Switchboard wizard is not available up front in 2010 (or did that happen in 2007). Finding it takes some effort.

[graccess]

I see what you mean, it's very limiting.