copy fields in forms

[V760838]

Hi everybody,



I want to copy a text box data of a form to the text box of another form. The first form has only two text boxes and a command button and the second form has many fields. Basically, I want to copy the user ID of the Log-in form to the other form as ID( which is a record source of a table) if the log-in is succesful. I do not know the vb code required to perform the action and where to use the code. Please help me. It would be easier for me if anyone can post an example.

[June7]

Options:

1. Pass the user ID value in the OpenArgs argument of DoCmd.OpenForm and ControlSource of textbox would be: = [OpenArgs]
DoCmd.OpenForm "secondformname", , , , Me.textboxname

2. Login form code sets value of textbox on second form.
Forms!secondformname.textboxname = Me.textboxname

3. Second form textbox ControlSource refers to textbox on first form (first form must remain open): = Forms!firstformname!textboxname

[V760838]

Thanks for your reply. I am only upto tables, forms and queries. VB coding is quite a jargon to me. However, I am able to copy the codes from databases.So, it is a bit difficult for me to understand the options given by you. It would be a great help if you could give me details as per the following.

tblLogIn

pk UserNo( number)
Password( Text)

tblTransaction

UserNo(item)
BookID(combo)
BookDetails
DateRequest(Date)
DateIssue
DateReturn

frmLogin

UserNo
Password
(Login Command Button)

frmBookRequest

UserID
BookID (combo)
BookDetails
DateRequest

frmIssue

UserID
BookID
BookDetails
DateRequest
DateIssue
DateReturn

Basically I want that as soon as the user clicks the log in command in LOG-IN form, the frmBookrequest should open with the USER ID of frm Log-in to be available in the userID text box of frmBookrequest.

How can I obtain the above. Thanks in anticipation.

[June7]

Option 3 I show does not require any code. It uses an expression in the ControlSource property of a textbox.

For Options 1 and 2, review this for a start http://office.microsoft.com/en-us/ac...010341717.aspx

[V760838]

Thanks my freind. I will try the option given by you and come back if I get any difficulty. Thank you for your help.