BrowseTo and DataEntry on navigation form

[Daimios]

Hi experts.

Here's the situation : I have a navigation form "Navigation", in which I have two navigation buttons : one for "New agent", the other for "Change agent".

New agent is linked to "Form_Agent_Entry", with DataEntry = Yes
Change agent is linked to a report listing all the existing agents, "R_Agent_Change" and each line has a button that "BrowseTo" form "Form_Agent_Entry", hopefully with DataEntry forced to No.

This last point doesn't work, as DataEntry seems to be impossible to modify.

Either I switch it manually in design mode to Yes, and my initial entry process works, or I set it to No, and my change existing entries process works. Apparently, the BrowseTo command within the navigation subform does not overwrite the DataEntry property, even though I set it to AcFormEdit.

Can anyone give me a hint ? This is driving me crazy.

Thanks guys

[ranman256]

Dont set the data entry property...open the form with the settings...

'for edit
DoCmd.OpenForm "fNames", , , , acFormEdit

'and entry
DoCmd.OpenForm "fNames", , , , acFormAdd

[Daimios]

Indeed, except that I wish not to open a new form, but to use the navigation subform instead, hence the BrowseTo command in which the acFormEdit/acFormAdd apparently have no effect on the Data Entry.

[Daimios]

Ok, I found a workaround :

I created two functions : setChange and delChange, that respectively set a global variable "ChangeMode" = "X" and = "".

If I go to the Entry form from the Change report, I call function setChange to set ChangeMode = "X".
If I go to the Entry form from the Initial entry button, I call function delChange to clear ChangeMode.

At Entry form load, system checks whether the ChangeMode is = "X". If it is, DataEntry is set to False and form is filtered on the specific agent to be changed. Else, system stays in DataEntry = True mode.

Not that elegant, but it works well