forms question

I am attempting to write a code so that when a command button is clicked, a
field in the form is automatically populated.

In the "On Click" event procedure, I want to have code that indicates the
following statement be entered into the field "Coverage Area":

ed^jurisdiction^ALL

I need the jurisdiction part of the statement to automatically be replaced
with the actual jurisdiction of the user. This particular field is located
on another table. The form that contains the command button is actually a
sub form within the larger form that contains the field "jurisdiction."

If everything was on one form, I would use the code:

Coverage Area = "ed^" & [jurisdiction] & "^ALL"

however, how can I refered a field (ie. jurisdication) when it is located on
a different table and essentially a different form?

Thank you very much for any assistance.

LB

Lauren,

Try:

Coverage Area = "ed^" & Me.Parent![jurisdiction] & "^ALL"

assuming the name of the control on the main form is actually
jusrisdiction; what the field is called in the underlying table is
irrelevant, since the code "reads" the control on the form, not the
field in the table!

HTH,
Nikos

Lauren B wrote:
I am attempting to write a code so that when a command button is clicked, a
field in the form is automatically populated.

In the "On Click" event procedure, I want to have code that indicates the
following statement be entered into the field "Coverage Area":

ed^jurisdiction^ALL

I need the jurisdiction part of the statement to automatically be replaced
with the actual jurisdiction of the user. This particular field is located
on another table. The form that contains the command button is actually a
sub form within the larger form that contains the field "jurisdiction."

If everything was on one form, I would use the code:

Coverage Area = "ed^" & [jurisdiction] & "^ALL"

however, how can I refered a field (ie. jurisdication) when it is located on
a different table and essentially a different form?

Thank you very much for any assistance.

LB