Linking of two forms

[sansri79]

Hi,

I am working in forms and I am beginner.

I have created two forms in my attached file. The first form is for Login Screen. All I need is once the agent enters the data in the login form and clicks the button “Click to Proceed for next screen”, the next form named “Customer Data” should open and the main page gets hidden.

Once the user gets the “Customer Data” form the first five fields i.e., Name, ID, Address, Location, Status should get the details auto-filled from the customer Data spreadsheet. For eg., when user clicks the “new record” button he can view the first five fields by default, the last two fields user can enter. Once user clicks “Save” button the two fields should be added into the customer data sheet.

Could anyone please help me on above. Please let me know if my requirement is not clear.

Thanks
Sansri

[protonLeah]

1. Your title does not conform to the Forum Rules.
2. You posted that same workbook here:
http://www.excelforum.com/excel-2007...-in-forms.html

RoyUK coded up a part of your project; however, you should not keep reposting and expecting others to do your work for you. We try to help you solve your problems...

[royUK]

This is different question about the same workbook. However the title does not comply with our Rules. Edit the title

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

In facr this question could easily be answered by searching the Forum. I have posted replies to very similar questions

[sansri79]

Hi,

Thanks for the reply.

I am trying to integrate two forms and I am getting error to run the form and normally I work with only form and this time I have to work with two forms.

And for better understanding purpose I have used the same workbook. I am just seeking help.

Could you please help me on above as I said I am a beginner and I am learning lot of new things from this.

Thanks once again
sansri

1. Your title does not conform to the Forum Rules.
2. You posted that same workbook here:
http://www.excelforum.com/excel-2007...-in-forms.html

RoyUK coded up a part of your project; however, you should not keep reposting and expecting others to do your work for you. We try to help you solve your problems...

[sansri79]

Hi,
I have created two forms.How can I link the two forms? If I enter data on one form and click the submit button another form should open. Could anyone please help me on this.

Thanks

[royUK]

I have added the code that I think you need

[sansri79]

Hi,
Thanks for the reply and code.

Infact the login form should be entered by the user, there should not be any data in it. The code which I have written for that is below:

Please Login or Register  to view this content.

The above code is working fine. Once the user clicks the "Click to Proceed for next screen" then the other form should open, and once the user clicks the new record then the first five fields should be filled with the data provided in the "Customer Data" sheet. once he clicks the "Save" button in the form all the data should cleared and when he clicks the new record the next row data from "Customer data" data should be filled in the first five columns. Only the last two columns provided in the form should be filled by the user i.e., "Call Status" & "Remarks" fields.

Please let me know if it is clear.

Thanks
sansri

[royUK]

My code for the login was to avoid user input errors - typos, etc

[royUK]

It's not clear. How do you determine which data to load. The code that I provioded gives you all the basics - have a go at adapting it

[sansri79]

Hi,
The user data does not belong to customer data. Both are entirely different. Fo eg., I am the agent who wants to enter the data so I need to type in my name and telephone number.

The customer data is the data whihc the agent should work upon. Once the agent clicks the "Click to proceed for next screen" and once he clicks the New record then the first five fields from the customer should be filled in the Customer data form and only the last two fileds should be input data and once he clicks the save button the last two input fields should be added in the customer data sheet and again he clicks the new record the next set of fields from customer data sheet should be visible in the form.

Please look into the attached file. Please let me know if it is clear.

Thanks

[royUK]

I would suggest that you adapt the combobox methos that I used in the other form. That's the best way - by using a combobox to select the name it avoids input errors & new names can still be typed in

[sansri79]

Hi,
Thank you for the suggestion. I have done in the same way and it is working fine. I am trying to pull records from the data sheet to the form.

I need first two records in the data sheet to be displayed in the form and rest of the columns the agent should fill and once he clicks the save button the data should get pasted in the data sheet. Below is my eg.,

Once the agent clicks "New Record" button in the form the first two fields should gets filled by taking the data from the data sheet like customer name should be aaaa and mobile number should be 1111 and the remaining data should be entered by the agent. Once he clicks the save button the data shouold be displayed in the data sheet.

Attached is the file.

Thanks for the help.

Sansri

[royUK]

Create a table of Customer details then use the ComboBox method that I outlined earlier

[sansri79]

Hi,
Thanks for the reply.

Could you please let me know whether is there any alternate way rather than giving the combox box. Just by clicking the new record button the first two fields in the form should capture from the first two columns (Customer Name and Mobile Number fields) of the data sheet and upon clicking the save button and again when we press the new record the next field(bbbb, 2222) captures and so on..

Thanks

[royUK]

You can search using .Find for a name entered in the first TextBox. This would work, but using a Combobox eliminates typos & searching for names that don't exist

[sansri79]

I am trying to automating the form as the data keeps changing everyday. Daily I will add fresh add data in the first two fields i.e., customer name and mobile number. every end of day I will run a report on the data sheet and a fresh data will be added in the first two columns for next days work.

Could you please some syntax or sample code for first text box (i.e, customer name to pull the record from data sheet) that would be great.

Thanks