VBA question ??

L

luanhoxung

Hi, groups !
Sorry if my question hear stupid. But i cannot find why it is.
I have command beside a combo for opening another form for adding new
record.
I use: Response = acDataErrAdded
in click event of command for requery the new adding in my combobox.
It works greatly but when i bring the code for my data at home, it
doesnot do.
I dont know where the matter come in.
Can anyone point me the reasons of this ?
Thanks.
Luan from VietNam
 
L

luanhoxung

Thanks for response, Jeff.
Because there were multi-information for a new record adding, i donnot
use NotInList.
I caught Dev Asish's post, use Response = acDataErrAdded replace
requery combo on Close event of entry form.
I assume that i was successful when i used this code in my office.
But in my home, it didnot work. i multi-checked my home code between
office code.
I can't find differences.
Hope anyone can explain this ?
Thanks in advance.
Luan from VietNam
 
D

Douglas J. Steele

You should still be using the NotInList event to open the update form in
Modal mode so that they have to complete it before they can proceed. Once
they've closed the form, the rest of the code in the NotInList event will
run.
 
L

luanhoxung

Thanks, Doug & Jeff.
I think i misunderstood. NotInList event is better way for me. I will
try it.
If have any problem then i will post back :)
Thanks again.
Luan from VietNam.
 
Top