I am using Access 2000.

I have a form which when opened does the following:
1. Gets the currently logged on Windows users code
2. Sets that user to a value on an unbound control on the form
3. Undertakes a Dlookup in a linked SQL Server table to get that users
access rights.
4. Assigns the user rights to another unbound control on the form.

A subform lists queries which can be run. The running of each query
is determined by the "user rights" in the unbound control on the form.

The problem I have is when I run the code to run the query it cannot
determine the value in the unbound control, however if I manually type
the "user rights" in the unbound control, then the code does work
properly.

I have tried to Refresh the form, Repaint the form, but this has no
affect.

Can some-one suggest a solution to this problem.

TIA