Unsure if this can be done with a Query

M

Matt

I have a database which 26 different sites use, each site has it's own site
code. I have made a query that runs when you open up the form they enter data
in, it asks for them to enter their site code, this brings up all the
information in the database relating to their sitecode. I would like to have
their site code automatically entered into each entry they make when they
open the form, is it possible to have this value taken from the input made
into the query which asks for their site code?

I tried using a setvalue macro but I am not too clued on when it comes to
this.

Thankyou.
 
M

Matt

Thankyou for your reply.

At the moment I have 26 individual forms which has the site code as a
default value. I am finding it time consuming to make changes as I have to
redo the form, and then copy that table 26 times, rename it and then insert
the default value again.

Maybe I should look at another way to run this database. Thankyou again for
your reply.
 
Top