May 30 2006, 04:13 PM
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?
May 31 2006, 08:24 AM
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.
May 31 2006, 11:04 AM
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.
May 31 2006, 11:55 AM
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.
Jun 7 2006, 12:09 PM
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
Jun 7 2006, 12:20 PM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here