Can't save record in main form!?

[gusbrunston]

I'm stumped! And I've done the keyword search several ways.

Source for main form = tblDeposits
(key) DepositID       Autonumber
      DepositNumber   Long integer (increments by 1)
      DepositDate     Date/Time
      Reconciled      Yes/No

Source for sub form  = tblDepositDetails
(key) DepDetailID     Autonumber
      DepositNumber   Long integer (from main form)
      Other stuff....

When I tab out of the last field in the first record of the sub form, the main form record has not been saved. I get an error msg that the record(subform) cannot be saved because there must be a related record in the table "tblDeposits."

I've struggled to save the record in tblDeposits so I can enter data in the sub form to no avail. I've put in command buttons, I've put saving code in the field(s) in the main form.

I can go to the table (tblDeposits) itself, enter records in datasheet view and then the form/subform works fine. But that seems nuts to me.

I've worked on this for a week. (Slept a little, ate twice, showered a couple of times, etc.)

Can you point me to the right button to push? Any help greatly appreciated.

Thanks,






Gus Brunston
An old PICKer
padregus@home.com

 

[gusbrunston]

Whoops! Was working from memory (not good).
My key in tblDeposits is DepositNumber (Autonumber)
Gus Brunston
An old PICKer
padregus@home.com

 

[gusbrunston]

Some progress...
In the main form there is a check box for "Reconciled". If I click that box then the form/subform works ok. But why do I have to click that checkbox? It has a default value of no. It should not be checked until the bank statement comes and the deposit shows on the statement. ??? Gus Brunston
An old PICKer
padregus@home.com

 

[gusbrunston]

Well I solved my own problem. (Does it seem like I'm talking to myself here?)
I deleted the relationship between the two tables. Why that fixed it I dunno... Gus Brunston
An old PICKer
padregus@home.com

 

[gusbrunston]

!
Bad idea!
Gus Brunston
An old PICKer
padregus@home.com