Is the best way:
I have a large form that contains about 200 fields. These are a mix of fields keyed in directly from source documents and fields that are calculated (to check the correctness of provided data or add extra information).
All the data were originally stored in one main table (not including look-up info), but Access was having problems with the table definition having too many characters (I try to use meaningful descriptions, and I think these might have made the issue worse). I have now moved the information into separate tables, linked through a main ID.
The forms now have issues with not being able to go to selected records, database crashes (frequent and appear to be random), and other painfulness :banghead: and I am seriously considering starting from scratch.
If anyone can provide some pointers in this area, I would be most grateful.
Many thanks
mcalex
- create one form and then open it differently for adding new vs editing existing records
- create one form to insert and one form to edit, where the edit form is bound to a query, and the insert form saves data following a button's click event.
- some other method?
I have a large form that contains about 200 fields. These are a mix of fields keyed in directly from source documents and fields that are calculated (to check the correctness of provided data or add extra information).
All the data were originally stored in one main table (not including look-up info), but Access was having problems with the table definition having too many characters (I try to use meaningful descriptions, and I think these might have made the issue worse). I have now moved the information into separate tables, linked through a main ID.
The forms now have issues with not being able to go to selected records, database crashes (frequent and appear to be random), and other painfulness :banghead: and I am seriously considering starting from scratch.
If anyone can provide some pointers in this area, I would be most grateful.
Many thanks
mcalex