VBA question ??

[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

 

[Jeff Boyce]

Luan

Read Access HELP on the NotInList event. It isn't necessary to add another
command button. The combobox can handle opening the new form for adding,
then returning, using Response = acDataErrAdded.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[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

 

[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.

 

[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.