input dialog box help needed

[MelanieP]

i need to find out how can i have a popup dialog box where they can enter in a value and the value must then populate to a non enabled field on a form. This is my trigger field and has to be filled in but they tend to forget this what i want to do is put a dialog box where they will enter their id and that id must then populate into a id field on the form which is disabled any help will be appreciated

thanks mel

 

[quest4]

I think the easieat way would be to just create simple form and have that open on some event like the form's OnOpen event. After the ID is entered you probably could even use DLookUp to get the rest of your data. Then close the form. But if you are only trying to get a username for who created and modified a record, there is a much easier way of doing that, use Environ("UserName"). hth.

 

[MelanieP]

They can only create new records and it is for the new records that they have to enter a id number. I have made it mandatory but coding with access 2.0 nothing always work as it should. The id is a number field. i just want a popup window to ask them what their id is and it should then put the id in the operator id field. we work with people that has never seen computers and south africa is so far behind

 

[quest4]

I uderstand what you are trying to do, I think. That is why I suggested using:
=Environ("UserName")
Put this in the default value of the ID field of table. Now you will autonmatically get the user's logon put into the field with every new record you create. Oh you can reset the tab stop for that controll to no. Environ is a little know Micrsoft command and it is extreamely powerful, you can find out lots of things with it. hth.

 

[MelanieP]

thanks i will try it

 

[quest4]

Your welcome, glad I could help.