Using a Form to update line items on Data sheet.

Main Question:

Is this possible and if so, how? I would like a User Form that allows you to enter a piece of information (ie an Acct or Loan Number) and search a database (on another sheet) -- once located, the other fields within the form will populate that line-item's data and can be editted. The newly entered information then saved to update that specific line within the data set, replacing the old data.

Rambling / Backgroun:
3 sheet book. results, stats(for reporting), data (database). Current layout is rough just to learn the machanics; most of this is new to me but I can usually learn something seeing it once thru. I've created the ability to ADD a new line item, to query the data set(thru adv autofilter) and return restulds on the front sheet based on criteria, save the work, and clear the results.

I've attached a rough copy of basically what I have so far .. Columns A - N on the 'data' sheet are really all that matters in terms of this book; additional colums found are for reporting purposes only and do not need to be included.

Originally Posted by JBeaucaire

Your file is not attached.

Are you wanting to hire someone to write your entire form for you, or assist you in tweaking your own form? If "assist", be sure you've already created your form and laid it all out and specifically note the things you need assistance on to get it working.

Hmm, not sure why the .xls didn't attach - Im receiving an upload error...uploaded a .doc for picture of form I can will create

No, I do not need to hire someone to create everything for me. My main concern lies in finding out if this is even possible before wasting hours researching it.

There is an Entry button that a user clicks on a main sheet that allows you to add line-items to the spreadsheet named "data". Basically, enter a line-item for a specific account with say..19 fields of information (acct number, address, state, zip, status, date1, date2, etc.)

The form I am looking to create will be exactly like this, only the Acct number (red on the form) will be the piece of information a user will enter..then click "Search" or "Populate" on the form -- the form will then populate its fields with the information from the data sheet line items. Any information can be editted then 'saved' to update the specific line on the data sheet, rather than write a new line.

Let me know if this is too vague or doesn't make sense and I will create a dummy form with no behaviour coding written behind it.