Passing Data From One Form to Another

[CharlieK]

Hello,

I am a newbie to Access. I have a form where fields are not bound to any table or query. Then I have a command button which opens up a second form (with a subform and a search field) of which the Record Source is a query. When the user types on the search field, the subform data gets filtered accordingly. What I want to do is to populate the fields on the mainform, using the record selected on the subform which is on the second form. Please help! I can provide further information if required.



Thank you!
Charlie

[ranman256]

You can fill in any box on a form by using the full path....
forms!form2!txtBox1= forms!form1.txtBox1

[CharlieK]

Thanks ranman256, for your reply!

Unfortunately, I already tried your code but it didn't work for some reason. The subform I have on the second form is a datasheet. It gets filtered based on what the user enters in to the text box (search field) I have on the same form. So when a user is double clicking on a specific record to select, there can be other rows on the datasheet which the user is not selecting. For an example, let's assume there are ten rows on the subform and the user types 'Add'. this can filter the records down to three. If the user sees the correct record out of the three currently visible, the user should be able to double click (any other function is also fine) on the relevant row and populate the data of that specific row on to Form 01.

Thank you!
Charlie

[aytee111]

What do you mean by double-clicking on a row? A datasheet view has many fields. Or are you talking about clicking on the record selector?

[CharlieK]

Since the subform is a datasheet, the records are displayed as rows of data. so when the user clicks on one of these rows, I want the specific record to be populated on the main form. I have attached Form 2 Below. On this form 2, you will see a search box and a subform. Subform records get filtered based on what is entered on to that search box. So when the records are filtered, I want the user to click on one of the records and populate Form 01 fields (Not shown here).

[aytee111]

You would use the OnCurrent event of the subform - when someone clicks on a record this will fire. Inside that event you can set the main form text boxes to the values on the subform.

[CharlieK]

I was thinking of adding the code to Dbl Click event. When the user double clicks on a specific record, that specific record gets updated on to the main form fields. but I can't seem to get the code right. Sorry, but I am pretty new to Access. Can you please help me with that?

[aytee111]

Either event is fine - as long as you can get it to fire you can use any event.

Change names as required: Forms!MainForm!fieldname=me!fieldname

[CharlieK]

I tried this code but it did not work. Can it be because of the section in bold (Forms!MainForm!fieldname=me!fieldname)? The subform is placed on another form (Form 02). So when we call the subform, should it be, Me!SubFormName.Form!SubFormFieldName ?

Edited:
I just tried it but didn't work. So frustrated!

[aytee111]

You are on the subform, so the "Me" is all that is required. Try adding "Forms!MainForm.Requery" after populating the fields.

Post your code.

[CharlieK]

Hmm.. That didn't work either. I think I am confusing you. Let me explain again.
I have a form, let's call it Form 01 which has unbound fields (text boxes). On this Form 01, I have a command button which opens (Pop up) another form. Let's call it Form 02. On this form 02, I have a Text Box which I am using as a Search field and a Sub form control of which the record source is a query. When I type in the text box on Form 02, it filters Sub Form Control data accordingly. What I want to do is for the user to be able to click on a record on the sub form control (which is on Form 02) and Fill Form 01 Data with that selected record data.

If this is not the standard way to do this, can you please suggest me an alternative?

Thank you so much!

[aytee111]

I asked you to post your code - not sure what is going on in your code.

It works for me on the double-click, without the requery, as long as I am clicking the selector button. How are you testing it?

[CharlieK]

Ok. I think I got it right now. Below is my code. The next question is, how can I get all the columns of the record added on to multiple fields on Form 01? Is it by repeating this same step for all the fields I need to populate?

Private Sub ProcessID_DblClick(Cancel As Integer)
Forms!Test!ProcessID = Me!ProcessID
Forms!Test.Requery
End Sub

[aytee111]

Either that or make your form1 bound to the same recordsource as the subform and repopulate all the fields by requerying the form with the Me!ProcessID as the filter.

[CharlieK]

Will that work if there are duplicate Process IDs in the query? For an example, subform has the same process step with two different decisions. Those two records will have the same ProcessID.