get value on form from another form

suppose i have three form. 1. Credit txn 2. debit txn 3. search
all form contain loan id and account no field.
when i press F3 key search form opened.

i want


when i am using credit txn, i press F3 key and open Search form
when i double click on Search field search form should be closed and double clicked fields Loan Id and Account no should be filled in Credit TXn
and
same should be happen with debit txn also.

Can it is Possiple
Thank You.

It's possible but maybe you should just use a combobox to select Loan.

I do not unterstand sir. Can you please describe in details?

Combobox (a 'dropdown' list) is basic Access functionality. Use it to limit values that can be selected for entry. This provides a list of know values for users to choose, in your case, Loans. Access Help has guidelines on creating a combobox that creates the dropdown list from a table. Also, review:

http://www.datapigtechnologies.com/f...combobox1.html

http://www.datapigtechnologies.com/f...combobox3.html

Thanks for help but i don't want to use combobox. i want to retrieve value from another from called search after double click in releted field.

Why don't you want to use combobox? Passing data between independent forms involves more work. However, if you must, options:

1. Code behind the Credit and Debit forms to 'pull' values from Search form.
Me.LoanID = Forms!Search.LoanID

2. Code behind the Search form to 'push' values to other forms.
Forms!CreditTXN!LoandID = Me.LoanID

The real trick is figuring out what event to put the code in and timing of code execution.

Combobox much simpler.

I don't want to use Conbobox because it takes lot of time to find a/c no.
in search form i have design as like where i can filter a/c no by name or address and other so that a/c no can be find soon
you have advice be to code behind forms but i don't understand where to put these code.
Thank You

Like I said, the real trick is figuring out what event to put the code in. Without knowing more about your db structure and form behaviors, hard to be specific. I can give you an example from my code:

Code:

...
'user prompt for entry of logout date
DoCmd.OpenForm "DialogGetDate", , , , , acDialog, "Logout"
If CurrentProject.AllForms("DialogGetDate").IsLoaded Then
    Me.tbxDate = Form_DialogGetDate.tbxDateDialog
    DoCmd.Close acForm, "DialogGetDate", acSaveNo
End If
...

That is just small part of a lengthy procedure that is called by a button Click event.


Why do you say it takes so long to find a/c number with combobox? The AutoExpand property should make it quite easy and fast.

because i have to find their a/c no by name because client forget their a/c no, some time by Proprietor name so i think combobox can't fulfill my desire.
I do not understand your code.
should I have to send sample database for analysis?
Thank You

Combobox can be set up as multi-column where the name is entered and as the user types, the dropdown list will show the name and a/c number. I think that is demonstrated by the second link I referenced earlier.

There is actually more to the process than the code I already posted. The code opens a form called DialogGetDate and pulls the user entered date from that form. The form is opened in dialog mode which suspends code execution from the calling form. Then there is code behind the dialog form that hides the dialog form which causes the code in the calling form to resume execution. Here is code that is behind the dialog form:

Code:

Private Sub tbxDateDialog_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
    If IsNull(Me.tbxDateDialog) Then
        MsgBox "Enter date."
    Else
        If Me.OpenArgs = "Logout" Then
            'Check if logout date falls within billed accounting period
            If Nz(DLookup("Final", "AcctgPeriod", "EndDate>=#" & Me.tbxDateDialog & "#"), 0) = True Then
                MsgBox "Date is within a finalized accounting period.  Enter another date.", vbOKOnly, "DateError"
                Me.tbxDateDialog = Date
                Exit Sub
            End If
        End If
        Me.Visible = False
    End If
End If
Me.tbxDateDialog.SetFocus
End Sub

Code for you could be simply:

code behind Credit form to open search form:

Sub Button1_Click()
DoCmd.OpenForm "Search", , , , , , "credit"
End Sub

code behind Debit form to open search form:

Sub Button1_Click()
DoCmd.OpenForm "Search", , , , , , "debit"
End Sub

code behind Search form:

Sub Button1_Click()
If Me.OpenArgs = "credit" Then
Forms!Credit!LoanID = Me.LoanID
Forms!Credit!AccountID = Me.AccountID
ElseIf Me.OpenArgs = "debit" Then
Forms!Debit!LoanID = Me.LoanID
Forms!Debit!AccountID = Me.AccountID
End If
DoCmd.Close
End Sub

That's about as specific and simple as I can get it for you. Adapt code as needed for your situation.

for sample i have described only 3 forms but in actual i have 50-60 forms. Should i have to repet (ElseIf Me.OpenArgs = "debit" Then
Forms!Debit!LoanID = Me.LoanID
Forms!Debit!AccountID = Me.AccountID) this code 50 -60 times ?
or i have to code another ways?

Yes, with this example, would have to repeat the statements 50 to 60 times. That's a lot of forms. Why are there so many? And they all open this Search form?

There are other methods, such as my other example code.

because i design separate form for separate work and many of form needed loan ID and Account no.
and search form is design for search loan id and account no (Client identity).
Thank You

"Separate form for separate work" means nothing to me. What is 'separate work'? Are these forms identical? Maybe you should just be applying a filter to a single form instead of building 50 forms.

just as For cach transaction i'm using Cash credit and cash debit form, for journal trancation i'm using journal credit and journal debit form, for a/c closing i'm using a/c closed form and for interest calculatin for a/c i'm using intacclosed form, for interest received i'm using interest received form and form int calculation int form is used, for emi(End month instalment) i'm using emi for and for interest calculation intemi form is used and so on.
and one think sir,
in above question, i'm using subform in search form and all form are opening in dialog mode.