MartyMatthews wrote:

> In registering people I have them enter their email address and then
> use that to open the appropriate update record. If their email
> address is not in the database I would like to open an insert record
> form.

I work mostly in asp and could not follow/get a handle you php code.

What I do is mannually add code at the end of the query.
- test to determine if a record gets returned
- if yes then go to (or redirect) update record
- if no then redirect to new page with form

You could use show region where if record is returned show the record
else show form