Form Field help

[Moddedout]

I want to accomplish two tasks to complete my inventory form but am having problems finding answers. Hopefully someone here can help.

1. I want to have a field for departments that other fields will populate depending on the department chosen. The department filed should be a drop down menu which I have no idea how to create either.

2. I want to have 5 fields that show up depending on a number entered in a box. For example: a user has 3 monitors and each monitor has a serial number that has to be entered in a seperate field. So a person would put in the number 3 in the monitors field and then 3 boxes for serial numbers would pop up.

If anyone can help me accomplish these two tasks I would appreciate it.

 

[Steve R.]

You are really asking questions that relate to the design/organization of your database. As a beginning read-up on normalization.

The reason that I say that is that source of your data for the department drop down list will be a table that contains the name of the department and the data associated with each department.

As for the number of text boxes becoming visible based on the number of monitors, that can be done using the "visible" property; but it would then appear that you would be headed for other problems. How would your database deal with a monitor being transferred from person A to person B?

 

[Moddedout]

Sorry but I am new to Access. I don't really know how to build what I am building. Would be nice if I could just get the fields in the form to appear and not appear based on what I want. As for updating the monitor being assigned to a new person getting updated I have a query that checks for duplicates and removes them which is working when the record is updated. Was trying to get more advanced with my form though. The database part I got working the way I want it to work. I want the form to show several fields that a person can enter data into and create new, update or delete existing records. I can send a screen shot of the form and get more detailed about the formats for each department. I was thinking that maybe I should do one form to choose the department and then create subforms for each one depending on the requirements. Again any help is appreciated and the link you provided did not work for me. Could be broken or related to security in IE8.