Data Entry Form unable to Enter Data

[npatel]

For some reason I can't type anything in the text fields. The form isn't locked and I can't figure out why it won't let me enter the data. Help please!

Form Name: Copy Of frmTransactions_Updatable

 

[plog]

Any form you want to directly interact with data (add/edit/delete) you should base upon a table, not a query. Your form is based on a query. Base it on a table.

 

[plog]

Then I looked at your relationships.

You need to focus on your tables--they are incorrectly set up. You should not have seperate tables (or fields) for debits and credits. They should all go into the same table, and their values should go into the same fields. For example:

TableTransactions
TransDate, TransCustomer, TransAmount
1/2/2008, 17, 90
2/3/2009, 18, 11
1/4/2010, 17, -90

The first 2 transactions are credits (positive), the last transaction is a debit (negative). Now, if I want to add them all up to get a balance its super easy because I just have to use the SUM function on my TransAmount field.

Looking closer at your tables, I don't see the need for 4 seperate tables for transactions. My guess is that all those tables' data should go into 1 table.

Focus on that, then worry about forms.

 

[missinglinq]

...Any form you want to directly interact with data (add/edit/delete) you should base upon a table, not a query...

Actually, many experienced developers only use a Query as the Record Source of a Form...but it's a Query based on single Table!

Many, many Queries based on multiple Tables are Read-Only, as you've found out.

Allen Browne has an excellent article that explains why Multi-Table Queries are frequently Read-Only:

Why is my query read-only?

The rest of Plog's advice sounds right on the mark! The First Cardinal Rule of Relational Databases is: It all starts with the data!

Set your Tables up correctly and everything else will fall in line!

Linq ;0)>

 

[npatel]

Thank You Guys, I will give it a try and if I have any questions I will ask... Thank You so much.

 

[npatel]

I have followed PLOG's suggestions, but now my calculation does not add up. I would like to subtract from Original Amount every time they make a payment in a balance due box and keep a outstanding balance due To Customers.