Hi this is going to sound like a very basic question, but I am creating a database in Access which is based on a number of unlimited tables. In my data entry form i have a number of combo boxes relating to these tables in which the look up field has no limit to list, as I require the users to be able to add new fields. This works fine, however, I want the fields in the table that each combo box relates to, to auto update when a new record is added. I have got as far as creating an event procedure for new data, but cannot work out how to get this to auto update. I have no knowledge of Visual Basic and am not sure where to start in writing script to get this data to update
Any help would be much appreciated
Thanks
Any help would be much appreciated
Thanks
Comment