Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combobox and Fields

Status
Not open for further replies.

Lhuffst

Programmer
Jun 23, 2003
503
US
I have several forms that have the same information plus some so I thought it was be a good idea to create combobox with the main category and then based on the selection, have the field display the appropriate fields. I know I can put all the fields on the screen but I want it to look somewhat nice (lol).
If I have
Code:
tbldata
fldDateAdded   -every form has this
FldSubmittedBy -every form has this
Fldsheets      -one form has this
FldNoTrucksInspected - yet another form has this
....
Form:
cboCategory: has the list of all the forms available

form1 has 3 fields: Date added, Submitted By, Sheets
form2 has 5 fields: Date Added, Submitted By, Meter Size, Bronze/Plastic, No Meters Scrapped

So when Form one is selected on the combo box, I want the next row to show form 1 fields
when form two is selected on the combo box, I want the next row to show form 2 fields.

Is there a way to do this?
thanks
lhuffst
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top