Combo box rowsource problem

DaveJHPT

Registered User.
Local time
Today, 10:23
Joined
Mar 17, 2005
Messages
64
Hi

I have a combo box on a form for which I want the available values to be a subset of the values from a table (which I can do), but for older records, I want the combo box to be able to display any value from this table.

(The combo is to select a member of staff who has been assigned to a case, and I only want current members of staff to be available for new records, but want to be able to display older records which relate to members of staff who have now left.)

The only way I can think of doing this is to have LimitToList = False, but that defeats the object of having the drop-down list in the first place.

Can anybody suggest a way of doing this please? I can get round it by having a text box AND a combo box, but wondered if there was a way to do it with a single control.

Dave
Salisbury UK
 
You can change the RowSource of the ComboBox in the Current event of the form depending on Me.NewRecord if you want. On existing records you may want to lock or disable the ComboBox to eliminate changing the value.
 
Aha!

Can't do exactly that as the form isn't bound (should have mentioned that!), but you've given me an idea how to do it.

Thanks!

Dave
 

Users who are viewing this thread

Back
Top Bottom