FP2003 - Form / Query Problem

[Sean]

Hi

Im new to this so please bear with me ......

I have created a form in FP 2003 which adds records to
an .mdb file.

When the user submits the form, I want the confirmation
page to show not only the detail that has been submitted
but also the record number, user name and IP address of
the users computer.

I decided (rightly or wrongly) that the best option would
be to put a basic query onto the confirmation page which
shows the latest record added for that user or IP, thus
showing the user what he had just added and also giving
him a record number should he need to chase his request.

The problem is, I do not seem to be able to retrieve the
user name at all. This is not even posted when the user
submits the form even though I have requested the user
name.

The IP address is added, so I wanted the query to compare
the current users IP address with that of the records in
the file, thereby displaying to the user the latest
record for his IP.

I cannot however figure out how to retrieve the IP
address from the users computer to compare against the
database records.

Does anyone know how this is done and can it be used as
part of the SQL statement.

All help appreciated

Sean.