Access 2010 Navigation Form (as opposed to the switchboard)

[WTE]

I am having some trouble with the new navigation capabilities in 2010.

When I add a form to the "form-in-form" navigation form (so that in one form you can press a tab which opens another form inside of it to enter data in) the form which is added is in edit mode. Anyone who presses that tab can then see past entries, which I am not thrilled about. I can replace the tab with a macro which will open the form in add-mode, but then it doesn't open the form inside the navigation form, but instead as a separate pane at the top of the screen.

How can I change the navigation tab to lead me to a add-mode form rather than an edit-mode form? Or is there a way the macro I try to make can be made so it opens the form I want in the navigation form?

Thank you for your help!

WTE

 

[Banana]

For benefits of other - "form-in-form navigation form" is technically called a "Navigation Control", basically combining the Tab Control and Subform into a single control. Access 2010 also offers a template, "Navigation Form" which makes use of that control to quickly generate a form.


But I'm not answering your question -

I had a look at the Navigation Control, and indeed there's no property to tell it to open in data entry mode or not. However it does support a Where Clause, which you can use an impossible WHERE clause... A good one would be "1=0" which should get you a blank form and thus act just like a data entry mode.

See if this suits your needs.

 

[WTE]

Hi!

Yeah, I see what you are saying. I can add a new macro where, with the where clause I can open the form in add-mode. Then problem then is that the form in the new macro is not opened in the navigation control. When i try to edit the current macro which, I can't change the where clause because it is VBA, and not a macro.

Thank you for your response: I am so new to this that everything I do takes forever, but I am slowly learning.

 

[Banana]

Hi -

There should be no need for a macro or VBA. You would just set the Navigation button's Navigation Where Clause property, which is on the Data tab when you are in the design form and set the focus to the button on the navigation control.

It should then open inside the navigation control with no past records.

Did that help?

 

[WTE]

Yes, it works! That should make it significantly easier to navigate the database. Thanks a million Banana!

WTE

 

[Banana]

Great. Thanks for reporting your success.

 

[malsony]

Hi, can anybody show me the syntax of the "Navigation Where Clause"? Thank you in advance!
I wanted to filter the target subform with the same ID of the master form. But I tried several formats, like:
subfrmXXX.ID = frmYYY.ID
[subfrmXXX].[ID] = [frmYYY].[ID]
[Forms]![subfrmXXX]![ID] = [Forms]![frmYYY]![ID]...
it just doesn't work...

 

[cj1997]

Hi,

Did you get a solution to this question? I have posed a similar question in another thread but haven't had a response yet. I am also trying to figure out how to navigate through the subforms with the navigation buttons of the Access 2010 Navigation Form, while defaulting to the same record in each (I want to be able to access the other records if need be, but would like to click through the navigation buttons without entering the record number each time when entering a new record).

Please let me know if you have a solution!

Thanks!!

 

[Pat Hartman]

I don't use the navigation forms but if I wanted to do this, I would change the "Allow Data Entry" property of the form to Yes. This is the "add" mode for a form. You don't need to change the RecordSource. If you wanted both options, Option 1 to open the form in add mode and Option 2 to open the form in edit mode, you could clone the form and have one version for each. Of course, you would need to remember to maintain both forms but if the only difference is a property setting, that shouldn't be a problem.

 

[Ley]

:banghead:I am having an issue with the Navigation Button, under the create ribbon, forms control section not being accessible. That is to say it is displayed but does not highlight and I cannot use it. Any suggestions as to why and what settings I need to change would be most welcomed. Thanks in advance.

I am having some trouble with the new navigation capabilities in 2010.

When I add a form to the "form-in-form" navigation form (so that in one form you can press a tab which opens another form inside of it to enter data in) the form which is added is in edit mode. Anyone who presses that tab can then see past entries, which I am not thrilled about. I can replace the tab with a macro which will open the form in add-mode, but then it doesn't open the form inside the navigation form, but instead as a separate pane at the top of the screen.

How can I change the navigation tab to lead me to a add-mode form rather than an edit-mode form? Or is there a way the macro I try to make can be made so it opens the form I want in the navigation form?

Thank you for your help!

WTE

 

[Ley]

HI. I am having an issue with the Naviagtion button you refer to not being accessible. It is merely greyed out. Any idea as to how I can access it, what settings I may need to change etc. Any help greatly appreciated. :banghead:

Hi -

There should be no need for a macro or VBA. You would just set the Navigation button's Navigation Where Clause property, which is on the Data tab when you are in the design form and set the focus to the button on the navigation control.

It should then open inside the navigation control with no past records.

Did that help?