Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rkg
 
Posts: n/a
Default Creating "records" in Forms

Hello everyone-

I am a complete novice to User Forms. Need your help. I have to create a
UserForm for Purchase Order information that will have multiple Items/Parts
(and its info) within a sub-structure. The structure will be as below:

PO Number <text_box_field
Vendor ID <text_box_field Vendor Address <text_box_field

-------------------------
Item # | Item Desc | Qty |
-------------------------
1001 | Cables | 10 |
-------------------------
1002 | Bolts | 1000| <= all text boxes
-------------------------
1003 | Bulbs | 5 |
-------------------------

<button for Add_Item

How should I create a tabular control/structure containing "record"/group
text-boxes into "records" for entering item information? In the above
structure, a scrollbar should exist next to the Item structure and display
only 2 records at a time.

Also, a button should dynamically add a blank "record" in item structure.

How should I achieve this? TIA for your help!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating "records" in Forms rkg Excel Discussion (Misc queries) 0 September 27th 05 08:44 PM
Creating forms in excel Dee Excel Discussion (Misc queries) 1 July 28th 05 02:45 AM
how to display single database records into forms for printing need help Excel Discussion (Misc queries) 1 July 6th 05 01:42 AM
Deleting specific records [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM
Creating templates from existing forms Marinasun Excel Discussion (Misc queries) 4 December 20th 04 08:54 PM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"