Overide combo box vaue

[tezread]

Correct me if I am wrong but is it impossible to overide the value of a combo box? A colleague has asked me to have a combo box that can allow the user to type in thier own choice? if its not in the list

 

[JANR]

Sure, just set the LimitToList Property to NO. But you have no control over the data validation

JR

 

[tezread]

I have limittoloist set to n but it own;t let me enter my own values though

 

[vbaInet]

You would need to create a form that you will use for new entries and use the Not In List event.

 

[tezread]

I have done some searching now and found a sample. I have added this in the notinlist event but i still can't add new values


see attached. the add patient form has the combo

 

[vbaInet]

You can add new values, after adding you requery the combo box.

Nb: I've not yet had a look at your db.

 

[boblarson]

I have done some searching now and found a sample. I have added this in the notinlist event but i still can't add new values


see attached. the add patient form has the combo

Which combo? The patient gender combo or the consultant combo?

 

[tezread]

Which combo? The patient gender combo or the consultant combo?

sorry - the consultant combo

 

[boblarson]

sorry - the consultant combo

Okay, of course it isn't working for you. You have the Not In List code but it is to a different combo name than what is there. Your current combo name is combo9 and yet you have code for: cbxAEName_NotInList

But no code for combo9.

 

[tezread]

Okay, of course it isn't working for you. You have the Not In List code but it is to a different combo name than what is there. Your current combo name is combo9 and yet you have code for: cbxAEName_NotInList

But no code for combo9.

ah - getting there now - have cleaned up code a bit more now

coming up with error message though (see new attachment)

 

[boblarson]

ah - getting there now - have cleaned up code a bit more now

coming up with error message though (see new attachment)

Well, yep - you are trying to update a nonexistent field:

rs!AEName = NewData

shouldn't that be

rs!Consultant_Name = NewData

 

[tezread]

brilliant stuff. thank you!!