filling a form in excel

  • Thread starter Thread starter Tomwireless
  • Start date Start date
T

Tomwireless

I Have 2 sheets, a database of items sheet and a form with a combo box to put
the record I get from the database. I want to pick a record from the
database, and add it to my form and have it bring the WHOLE record with it to
the form not just the combo box cell. Both sheets have the same field names
in them.

anyone have an idea on this?

Tom
 
I think you misunderstood, Its like filling in a order form from a database.
I have the database and the form but need to find a way to bring the data
over to the form and autofill the rest of the record when the first cell is
entered.

Item Decription cost
xxxx autofill autofill
xxxx autofill autofill
 
If you are using a Userform from within VBA then check out the below link by
MVP Debra Dalgleish .

http://www.contextures.com/xlUserForm01.html

If you have created a form within excel; then check out help on function
VLOOKUP()

--
Jacob (MVP - Excel)


Tomwireless said:
I think you misunderstood, Its like filling in a order form from a database.
I have the database and the form but need to find a way to bring the data
over to the form and autofill the rest of the record when the first cell is
entered.

Item Decription cost
xxxx autofill autofill
xxxx autofill autofill
Click to expand...
 
Back
Top