Open a Form together with there Values

[bitzgam]

Hello everyone I have made a main form(ApplicantList) and another form(ApplicantDetails) for new applicants which the the DataEntry Property set to Yes now my concern is If double click the LastName of FirstName value on the main form I want to popup the second form which has have all there information.. Any Help is appreciated
See Attachment

God Bless

 

[ConnorGiles]

Hi Bitzgam,

The double click event procedure on the LastName and FirstName

DoCmd.OpenForm etc....

 

[pr2-eugin]

Hello everyone I have made a main form(ApplicantList) and another form(ApplicantDetails) for new applicants which the the DataEntry Property set to Yes now my concern is If double click the LastName of FirstName value on the main form I want to popup the second form which has have all there information.. Any Help is appreciated
See Attachment

God Bless

Your Form set up concerns me. You normally have to have it the other way around. ApplicantDetails will be the one to collect the information, that includes the FirstName and LastName. Setting it to Data Entry = Yes will always open the form in New Record, regardless of if it has a record.

If you would like to explain what you want (over what you have), maybe we could come up with a different solution...

 

[bitzgam]

Hi Bitzgam,

The double click event procedure on the LastName and FirstName

DoCmd.OpenForm etc....

hello Sir thank you for the quick response, I dont really know how to make a code using DoCmd.OpenForm coz im really new in Access i did just start learning access last month. Im learning on the process Sir, you you mind if you'll help me make some code? if it doesn't bother you Sir
More Power
GodBless

 

[bitzgam]

Your Form set up concerns me. You normally have to have it the other way around. ApplicantDetails will be the one to collect the information, that includes the FirstName and LastName. Setting it to Data Entry = Yes will always open the form in New Record, regardless of if it has a record.

If you would like to explain what you want (over what you have), maybe we could come up with a different solution...

Hello Sir, thank you very much for your quick response and concern. I actually come up with that coz I imitate it on the access default databases in the Student Database. If you have a solution Sir, I;m glad to hear it

More Power
God Bless

 

[ConnorGiles]

Hey bitz,

http://msdn.microsoft.com/en-us/library/office/ff820845(v=office.15).aspx

I would say learning via actions is the best way. Me just giving you code wouldn't help you in the slightest

Hope this helps

 

[pr2-eugin]

If you have a solution Sir, I;m glad to hear it

To give a solution, I need a problem. Could you please describe what you wish to achieve? In simple words explain your problem.

 

[bitzgam]

Hey bitz,


I would say learning via actions is the best way. Me just giving you code wouldn't help you in the slightest

Hope this helps

Indeed Sir,
Now I did get it using DoCmd.OpenForm but the problem now Sir is when I try to click another name it always popup the default form which has the first value. I know you saw my attachment for sure sir, in that case the Main form has a 1st value of Pepper Mint (Applicant First and Last Name) but when i try to click to another value the second form always popup in same details of Pepper Mint. How can I solve that Sir that when I try to click for a certain value example Carl Bact then the second form should popup the details of Carl Bact.


More Power
GodBless

 

[bitzgam]

To give a solution, I need a problem. Could you please describe what you wish to achieve? In simple words explain your problem.

Sir here's the problem. In my Attachment the first value of the Main form is Pepper(Firstname) when I click Pepper the second form(ApplicantDetails) is popup with Pepper's Details. But when I clicked another Value samp. Bact which is the 2nd value on the Main Form the second form Popup but with the details of Pepper. So how can I able to get the result which is the details of the value that i clicked?

Thanks Sir
More Power
God Bless

 

[ConnorGiles]

Hey Bitz,

Before I answer this question, may I ask why you don't add another tab which has this list of people there ?

Because if they will see this form any ways, then surely adding this alongside Government ID would be beneficial and reduce the need for the 2nd form?

Sub form the other form into the current one then should be solved. In my head anyways

 

[bitzgam]

Hey Bitz,

Before I answer this question, may I ask why you don't add another tab which has this list of people there ?

Because if they will see this form any ways, then surely adding this alongside Government ID would be beneficial and reduce the need for the 2nd form?

Sub form the other form into the current one then should be solved. In my head anyways

actually Sir the sub form(ApplicantDetails) is applicant details which the DataEntry set to Yes to be able to add a new applicant automatically. I just want that in my main form when i click the name of the applicant then the sub form(ApplicantDetails) will popup with their complete details.

More Power
GodBLess