Unable to add new record

E

Emma

Hi all,

I have a main form on which there are two option buttons. Depending on the
option selected form linked form will open via the following select case
statement:

Private Sub Frame_Contract_Type_AfterUpdate()
Select Case Form_Tbl_Master_Jobs!Frame_Contract_Type
Case 1
DoCmd.OpenForm "frm_tbl_contracts_Int", acNormal, , Me!cbo_Account_No =
frm_tbl_contracts_Int!txt_Account_No, acFormAdd, acWindowNormal
Case 2
DoCmd.OpenForm "frm_tbl_contracts_Biopsy", acNormal, ,
Tbl_MasterJobs!Account_No = Account_No, acFormAdd, acWindowNormal
Case Else
DoCmd.GoToControl "comments"
End Select


When the option button is selected the linked form is supposed to open with
the account number already populated
(Tbl_Master_Jobs!cbo_account_No=tbl_contracts_Int!txt_Account_No) and with a
new Contract No. incremented from the last record entered (I have the code
for that but have not entered it yet). I am getting the error "Object
required". Why aren't my forms being linked?

I don't know if this has anything to do with my problem but , the linked
form has another form linked to it (sfrm_Addendum_Line) which is linked to
frm_tbl_contracts_Int as follows:
Sfrm_Addendum_Line!Addendum_Master_Cnt_No=frm_tbl_contracts_int!Contract_Main_No. This form work okay.

Sfrm_Addendum_Line should be filtered on the Contract_Main_No.

My problem is that when I select the option button to open
frm_tbl_contracts_Int, I cannot add a new record and the
Tbl_Master_Jobs!cbo_account_No is no populating
tbl_contracts_Int!txt_Account_No
 
E

Emma

One more thing, When I delete all the records from my contract table, the
frm_tbl_contracts_Int comes up totally blank, no fields nothing. I think
I've run into this before but can't remember for the life of me how to fix it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top