I am not an expert to Access however, I have 3 tables which are used to filter 3 combo boxes( Search Source 1, Issue 1 and Detail Issue 1). I may need to update the tables with additional info however this corrupts the information I have already selected in my form prior to adding the new info to any of the tables. Is there code I need to write to protect the info from changing?

Frankly, I haven't a clue what you are talking about. Can you elaborate on what you mean by tables used to filter combos? A combo is generally based on a query of data in a table and used to populate a field in another table.

If you need to add additional fields to a table, you do so in Design mode. This should not corrupt anything. If you need to add additional records, just do so, again that shouldn't corrupt anything.

I have attached a zip of a Word doc explaining what some of my issues. I hope this clears up what I am trying to accomplish.

Thank you in advance for your help.

Veronica

Well first you have a design problem that needs to be fixed. Whenever you have fields with namnes like Issue1, Issue2, etc. that usually constitutes a repeating group which violates normalization rules.

You should have child tables to record the Details and isuues, etc. Where each Issue is a record, not a field.

Secondly, you are using Cascading combos, but you may not be requerying the combos after you add records. Can't tell from the info you sent.

Scott,

I have been following this tread and I followed your advice and added a new field to my payments table in design view. However, the changes did not occur in the form. Payments is a linked subform in the mainform- funders. Thank you


Witty

Adding a field to a table does not automatically add it to an existing form. You have to open the form in Design mode to add a control for that field. If the form is based on a query and not directly on the table, then you have to add the field to the query first.