Combo Box, Not In List event, Access 2010 (2 Viewers)

[vbaInet]

You've obviously done something in your db that's causing this behaviour. Upload your db and I'll take a look.

 

[cluendo]

http://www.mediafire.com/?gzkz8saciywubx6

It 2010 access file. I do not know how to covert into older versions. Hope you will be able to open it.

 

[vbaInet]

Unfortunately not. I don't have 2010 on this laptop. I've got it on another laptop at home but I don't use it and won't be logging in at home anyway

Convert the db to 2007 or older. Here's how:

http://office.microsoft.com/en-us/a...se-in-an-earlier-file-format-HA010341553.aspx

 

[cluendo]

Ok. I cannot save it as older version because I use "some new features" lol.

But I'm working a new one, fresh one It will be here in 10 mins.

 

[vbaInet]

Ok, next time try creating a new older version db and copy and paste from current to new.

 

[cluendo]

Here you go:

http://www.mediafire.com/?54g7m5fcewgu1bo

I made everything again, but still get same error.
Check it if you have little time!
Thank you!

 

[vbaInet]

You know you can post your db on this forum. Here's how:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

I'll take a look when I can if no one else has chimed in.

 

[cluendo]

Thank you. I'm working on it as well.
I never thought that notinlist event is such a pain. or it's just me.

 

[rsdharan]

You need to refresh the combo box after you add the record to the AddForm. Use the Requery method of the combo box.
yes i agree with vbaInet. It is an effective method to requery the combobox property after upadate event triggers

 

[rsdharan]

You need to refresh the combo box after you add the record to the AddForm. Use the Requery method of the combo box.
yes i agree with vbaInet. It is an effective method to requery the combobox property after upadate event triggers

yes i agree with vbaInet.

 

[cluendo]

Ok guys, somehow I figure it out myself. I will post my code today, to check if it is efficient and do not have logical problems (although it is working)

vbaInet - big thanx for you, but don't go away yet!