Continuous Form Default Value

[Guest]

I am using a button on a continuos form to open another form in AddMode. No
problem. I then want to set the defualt value of the newly opened form,
frmISSAdd, to = the LocID field on the continuous form. Since the value in
any of the forms will be the same as they are filtered from a listbox, It
doesn't matter which of the forms Access takes as the value.

I tried using =[forms]![frmDiscipline]![subDiscReferral]![LocID]

The form opens in Add mode and then I get a #Name? in the LocID field.

 

[George Nicholson]

If [subDiscReferral] is the name of a subform, your syntax is probably wrong
unless it also the name of the *control* containing that subform.

How to Refer to Form and Subform Properties and Controls
http://mvps.org/access/forms/frm0031.htm

HTH,

 

[Arvin Meyer [MVP]]

Try:

=[forms]![frmDiscipline]![subDiscReferral].Form![LocID]

 

[Guest]

I tried that and several others from the web site in the above reply to no
avail. Is there a way to have a form open in add mode and have the new form
open with the value from the continuous form?

docmd.openform "frmIssAdminAdd",,,,acAdd,,"LocID ="& Me.LocID

I have tried that and this above, but it still comes up blank.
--
Thanks As Always
Rip

Try:

=[forms]![frmDiscipline]![subDiscReferral].Form![LocID]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am using a button on a continuos form to open another form in AddMode.
No
problem. I then want to set the defualt value of the newly opened form,
frmISSAdd, to = the LocID field on the continuous form. Since the value
in
any of the forms will be the same as they are filtered from a listbox, It
doesn't matter which of the forms Access takes as the value.

I tried using =[forms]![frmDiscipline]![subDiscReferral]![LocID]

The form opens in Add mode and then I get a #Name? in the LocID field.

 

[Arvin Meyer [MVP]]

This line is incorrect:

docmd.openform "frmIssAdminAdd",,,,acAdd,,"LocID ="& Me.LocID

It should look like:

docmd.openform "frmIssAdminAdd",,,"LocID =" & Me.LocID

assuming that the second LocID (as in Me.LocID) is the name of the textbox
holding the value of the LocID field.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I tried that and several others from the web site in the above reply to no
avail. Is there a way to have a form open in add mode and have the new
form
open with the value from the continuous form?

docmd.openform "frmIssAdminAdd",,,,acAdd,,"LocID ="& Me.LocID

I have tried that and this above, but it still comes up blank.
--
Thanks As Always
Rip

Try:

=[forms]![frmDiscipline]![subDiscReferral].Form![LocID]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am using a button on a continuos form to open another form in AddMode.
No
problem. I then want to set the defualt value of the newly opened
form,
frmISSAdd, to = the LocID field on the continuous form. Since the
value
in
any of the forms will be the same as they are filtered from a listbox,
It
doesn't matter which of the forms Access takes as the value.

I tried using =[forms]![frmDiscipline]![subDiscReferral]![LocID]

The form opens in Add mode and then I get a #Name? in the LocID field.