Default value from another form

[hitesh_asrani_j]

I have a user and pass form which leads to a different form...



Is it possible so that one of the fields from the second form takes the value from the user and pass form...

[pdebaets]

In the control source for the control on the 2nd form, put:

=Forms!MyFirstForm!MyFirstFormControl

... where MyFirstForm is the name of your first form, and MyFirstFormControl is the name of the control on the first form who's value you want on the second form.

[hitesh_asrani_j]

Still not getting the reply from the user form

[pdebaets]

I think I will need more info before I can help you. What do you mean by "the reply"? Can you provide more explicit information about what is happening, and what you want to have happen?

[hitesh_asrani_j]

I meant that the Original Form is not taking the username that of from the User and Pass form.... :'(

[pdebaets]

Is the user and pass form still open? If it is closed, then you may need to save the username and password in global variables. Then you can have a simple function which returns the user and pass. let me know if you need examples.

[hitesh_asrani_j]

The userform is closed

now how can we do it

[hitesh_asrani_j]

Sorry for delay was out and away so could not reply for so many days

[pdebaets]

Create a new module. Enter this:

public gstrUserName as string
public gstrPassword as string

public function GetUserName() as string
GetUserName = gstrUserName
end function

public function GetPassword() as string
GetPassword = gstrPassword
end function


... now in your "enter username and password form" in your OK button OnClick event procedure put

gstrUserName = Me!MyUserNameControl
gstrPassword = Me!MyPasswordControl

You can use the GetUserName function to return the user name in a control on another form using this control source:

=GetUserName()

[hitesh_asrani_j]

it says

The object you are referring to is closed or does not exist :|

[hitesh_asrani_j]

Done I edited a little and it worked

[hitesh_asrani_j]

No still not working....
The field is highlighted with the correct user name... but the table is updated with out the User/Agent name empty in it...
please help
please

[pdebaets]

Now you want to update a table? Is this a separate question?

Try binding your form to the table. If you need more information on this, please create a new topic post.