Combo Box Issue in Continuous Form

[nobull613]

I have a combo box (Employee) whose recordset is filtered by the selection in another combo box (Department) on the form. To pull the employees for the selected department, I have the Employee combo box requery On Click. The issue is that the list is requeries for every "instance" of the continuous form. Previously entered employees for other departments are no longer visible in the form when the department is changed. The data is correctly stored in the table but it is very confusing for the users.

Is there any way to have the recordset update only for the active form versus all of occurences of the continuous form?

Thanks,

 

[TheAceMan1]

How are ya nobull613 . . .

Requery [blue]Employee[/blue] from the [blue]AfterUpdate[/blue] event of [blue]Department![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[nobull613]

If the list of employees for the newly selected department does not include an employee that was picked previously for another department, will they "disappear" from the form? The data is in the table but the requeried recordset no longer includes them.

 

[Pampers]

Hi nobull613,
Maybe it would be a better design to do the entering of data in a single form, while you all the entries in the on a continuous subform....

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

nobull613 . . .

It sounds as if the [blue]Employee[/blue] combobox is [purple]bound![/purple]

Is this correct? . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[nobull613]

It is bound. Both fields are bound.

 

[TheAceMan1]

nobull613 . . .

Your problem involves a changing recordset (probably via a WHERE Clause based on the Department combo) returned by Employee.

Each Employee combo in the field doesn't have its own recordset! They're all tied to whatever the current recordset may be!, and if the current doesn't include prior selections access displays a blank (what else can access do). In fact if scroll up and down you'll actuall see current visables, disappear!

A subform would relieve you of the Employee combobox!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SeeThru]

Or, switch to single for view, and requery the combo box using oncurrent, or when the data it depends on is changed

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk