Lookup Tables not saving information

[sugar05]

Hi ppl,

Anyone who thinks that they may be able to help me, there is a copy of the database at :

http://members.iinet.net.au/~a.beardsley/database/StaffProLearning.mdb

Here is my problem, as you will see. In the from called frmStaff, I have created 2 lookup tables that work fine in the main form. In the subform under activites though, I have attempted to create a lookup form for Name and Location of activities. It does not appear to be storing the information from previous entries though. My aim is so that when someone goes to enter a new activity name or location, the data will be saved and be in the list for the lookup next time with a different entry, however, it does not appear to be storing the information in the appropriate table. Any ideas on how to fix this?

Regards,
sugar05

 

[llkhoutx]

On the AfterUpdate event of each of those fields, you have to add the filed to the underlying table. Seach this site for "NotInList" code.

 

[sugar05]

Thamks for your help llkhoutx. I have search for the code and got a copy of it, I think it's what im after. Only problem being I have never attempted to do coding in access before. Can someone tell me where I need to start, or if you have some spare time, edit and save the changes to the download thats avalible?

Best Regards,
sugar05

 

[sugar05]

http://forums.whirlpool.net.au/forum-replies.cfm?t=439525