Overide combo box vaue

tezread

Registered User.
Local time
Today, 18:10
Joined
Jan 26, 2010
Messages
330
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
 
Sure, just set the LimitToList Property to NO. But you have no control over the data validation

JR
 
I have limittoloist set to n but it own;t let me enter my own values though
 
You would need to create a form that you will use for new entries and use the Not In List event.
 
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
 

Attachments

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

Nb: I've not yet had a look at your db.
 
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?
 
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.
 
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)
 

Attachments

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
 

Users who are viewing this thread

Back
Top Bottom