Data Entry Form - Adjusting Other Fields

[kdbailey]

I am building a data entry form. One of the fields is for employee name. Based on who you select, another field titled "Team" also is adjusted based upon which team that employee is on.



For instance...

The current record shows Employee John Doe, team Shop Floor.

If I change employee to Steve Adams, I want team to change to Finance.

The form is "Report style" as in that Default View is set to "Continuous Forms", so more if there are 10 records, all 10 records will show.

How do I adjust a separate field within the same record that is being adjusted currently?

[Bulzie]

Few ways to do it. I usually add the 2nd field into the combo box so that first combo box will search on the name but also include the Shop Floor as a 2nd field. Or if you do not want to show it in the combo box, you can set the wideth of that field to 0 so it will still be in the combo box but will not show in the list. Then in the AfterUPdate of the combo box, you move the Shop Floor value to the other field:

Me.Team = Me.Employee.column(1)

[kdbailey]

Issue resolved.

By changing the textbox value for "Team", it automatically recognizes which record you currently are one. It only changes the one textbox - changing the value within the record.

[kdbailey]

On the same topic, is there a way to scan through the other records?

This is a project management form in which I am displaying the team. I only want one Owner which is the first field "Role". If I change the Role field to "Owner" on one record, can it scan through the other records and change them to "Participant"?