Prompting from a query

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

When a user clicks on a button to open FormA, it prompts
the user for his/her ID. The query then searches for all
the records with this user ID. Then the form opens to a
blank record - The user will then have to enter his/her
userID a second time to enter a new record.

Is there a way that the userID from the prompt can be
automatically entered to the form when it opens?

Thanks
 
Yes, you can put it in the Default Value in the field's property.

Are your users logging into access or the computer with this ID? If so,
there is no need to make them type it. You can have access read it and use
it. How you do so depends on whether you want to use the Windows UserID or
the Access Security UserID.

Rick B


When a user clicks on a button to open FormA, it prompts
the user for his/her ID. The query then searches for all
the records with this user ID. Then the form opens to a
blank record - The user will then have to enter his/her
userID a second time to enter a new record.

Is there a way that the userID from the prompt can be
automatically entered to the form when it opens?

Thanks
 
The user logs in to Access with the Windows log on.

What do you mean by put it in the field's default value?

Thanks
 
In the field's property box, click on the "Data" tab. in the "Default
Value" ...

=CurrentUser



Rick B


The user logs in to Access with the Windows log on.

What do you mean by put it in the field's default value?

Thanks
 
Thank you
-----Original Message-----
In the field's property box, click on the "Data" tab. in the "Default
Value" ...

=CurrentUser



Rick B


The user logs in to Access with the Windows log on.

What do you mean by put it in the field's default value?

Thanks



.
Click to expand...
 
Back
Top