Need to have my form display previously entered information

JBeeNC

New Member
Joined
Nov 22, 2019
Messages
28
Office Version
  1. 2013
Platform
  1. Windows
Hello everyone,
I am needing assitance to have a form, once a PO number has been used, for the form to display what information was entered previously for that number. If I click on a number previously used the form just comes up blank. I don't want anyone to be able to modify the original information that was entered. How can I make that happen? I have images below to example. You can see the information fed to the Tracker worksheet but when I choose one of those PO numbers in my form, it comes up blank and I need it to show what was entered prior. Please advise and thank you.
 

Attachments

  • Form snip.PNG
    Form snip.PNG
    81.6 KB · Views: 4
  • Billable snip.PNG
    Billable snip.PNG
    5.1 KB · Views: 4

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
I would think we need to have a lot more specific details which we cannot get from your images.

Like:
If I enter 12 into TextBox22 then search for 12 in column G of the active sheet and load the values from column H of same row into Textbox 2

And so on and so on.
We would need to know the name of all the Textboxes and where on the sheet we might find that value.
 
Upvote 0
Hi,
Thank you for the reply. Here is a link to my file. Please let me know if you have any other questions. I appreciate you reaching out!
https://drive.google.com/file/d/0B_ZwvxbNpGcMR0d4Sy1NSGNYekxXTEhlOTZWclNqay1UbC1N/view?usp=drivesdk
I never click on links and download files to help people here.
But there are others here on the forum who do that.
So since you would prefer to get your help this way I'm sure someone else on the forum will be able to help you.
 
Upvote 0
Hi,
Here are some snapshots that may help. I can't define every single cell for each PO number, there are 200 PO numbers they can select from. Does this help?
TYIA
 

Attachments

  • Capture1.PNG
    Capture1.PNG
    21.8 KB · Views: 2
  • Capture2.PNG
    Capture2.PNG
    3.1 KB · Views: 2
Upvote 0

Forum statistics

Threads
1,214,804
Messages
6,121,652
Members
449,045
Latest member
Marcus05

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top