Datasheet combo box empty

[Annette]

I have a form that is in datasheet view. One of the fields on the form
is a combobox for ClientID. The rowsource for the combobox is a query
that looks for active clients and displays their name. If a client is
not active, the query for the rowsource will not select them.

I do not have a problem with the form being filled out, but I do have
a problem when a client becomes inactive. All the data appears on in
the datasheet view with the exception of the combobox for the ClientID
as the rowsource for that field will not select inactive clients. If
the client is still active, their name will appear, but if they are
inactive the name will not appear. Is there a way that I can limit
client name selection from the combobox by using the rowsource query
to only search for active clients, however have the form display the
"inactive" client'sname for the records that were previously entered
before the client became inactive?

 

[Bob Quintal]

m:

I have a form that is in datasheet view. One of the fields on the
form is a combobox for ClientID. The rowsource for the combobox is
a query that looks for active clients and displays their name. If
a client is not active, the query for the rowsource will not
select them.

I do not have a problem with the form being filled out, but I do
have a problem when a client becomes inactive. All the data
appears on in the datasheet view with the exception of the
combobox for the ClientID as the rowsource for that field will not
select inactive clients. If the client is still active, their name
will appear, but if they are inactive the name will not appear. Is
there a way that I can limit client name selection from the
combobox by using the rowsource query to only search for active
clients, however have the form display the "inactive" client'sname
for the records that were previously entered before the client
became inactive?

yes, by using the form's current event to c hange the combobox
rowsource to the full list if the client is inactive and jest the
filtered list if the client is active. But it will be slow when
changing recortds.

Another way, if yoiur client ID does not get changed after the record
is created, is to change the row source to the filtered query only
when creating a new record.and resetting it after saving the record.