Unbound Form not allowing data input

[Arevin]

Good morning everyone.

I've been working on a database for the past month, with Access 2010, and have been coming up on problem after problem.

So, now I've decided to go at this from a new angle.

I have 4 tables with one-to-many relationships set up from tEmployee->tDeposits; tEmployee->tSales; tEmployee->tPumped.

Everything on the form is in the form of a textbox except for the Employee name which is a combo box with a macro to open up another form if the employee name is not in the list.

My form is unbound and has all four tables included and in Record Source I have

SELECT tDeposits.DDate, tDeposits.BDeposit, tDeposits.Charge, tDeposits.Debit, tDeposits.Credit, tDeposits.Coupons, tDeposits.Certificates, tDeposits.Received_On_Account, tDeposits.DError, tSales.Native, tSales.Non, tSales.Other, tSales.Other_Sales, tSales.HST, tSales.Received_on_Account_Sales, tSales.Customers FROM tSales INNER JOIN tDeposits ON tSales.ID = tDeposits.SalesID;

That was automatically put in when I created the form.

Now, when I go into Form View, the only thing that allows for any change is the Combo box. I can't enter any other data in the form.

Thank you for your time.

[MMcCarthy]

The problem is your query is not updatable. You will probably have to use subforms rather than trying to do it all in one form.

[Arevin]

That's what i thought as well. I'm going to give this a try. I only wanted to do it in one form w/o subforms because I'm a neat freak and it just looks messy with 2 or 3 sub forms.
THank you