Hi everyone:

I am trying to pass a paramater from a parent form to a child form.

I would like to know how to "reference" the current record I am on in my SELECT statement.

Example:

I have a parent form called "jurisdictions", with a field called "njuris_id".

I want to pass the number in the njuris_id field of the parent to the njuris_id field in my child form (County_Assignment).

My statement isn't quite complete:

So far, I have>

SELECT (njuris_id) AS num FROM (jurisdiction)


How do I indicate CURRENT RECORD in the syntax, so that SQL knows I am trying to pass the number of the current form to the child?

Is there a word that must follow the word SELECT?

I hope I am saying this clearly enough for someone reading this to understand. I have to be able to let SQL know that I want to pass the number of the CURRENT record to the child when I do my assignment.

Basically, I just need to know the syntax of that proceedure.

If anyone can help me with this line of code I would appreciate it very much.

tia
jcd