Data Entry

[connerlowen]

Hi,

I am creating a database that will take data entered by the employees, and some data already in the database, to generate quotes. The company is currently using two different MS Excel sheets to do this. One sheet quotes individual parts, and the other quotes assemblies and their sub-assembly parts. All of the following data relies on that. How can I make the database populate only certain fields within a record to fill out? There is potential for up to 5 precious metals, and 10 base metals. No part is Guaranteed to have a certain number of either. I want the database to be able to take a number from a drop down menu 0-5 and only show that many fields for the corresponding precious metals. I have Fields for up to 5 Precious Metals, and 10 base metals in my tables, but I do not want all of this to show.

Thanks,

Conner

 

[JHB]

You could hide some of the fields, depending of the combobox, but you can also have different subforms and load them depending of the combobox.

  If Me.MyCombo = 1 Then
    Me.TheSubform.SourceObject = "FirstSubform"
    ...
    ..