Recent content by essence

Thank you both. This works perfect.

I am getting a type mismatch error on this if statement. If DCount("*", "tblEvaluation", "[ECycle] = " & Forms![frmSelectMgr]![Text42] And "[EvaluatorMgr] = " & txtRandomMgr) = 1 Then MsgBox ("This user has already evaluated a manager") End If This piece of code is placed on a command...

Ok, I'll check the relationships.

This thread is a follow-up that relates to the system of the my last. I have a main form with project id and a subform with financial data linked to the main form by project no and p_id. The subform itself has an autonumber primary key field for each transaction. The subform also has the fields...

Originally, I was not getting it to work but I checked the name of the text boxes/combo box and it was not the same as in the code. Now, that part works great. So yes, I got it okay. Thanks again.

Oh Bob, you're a genius! Thanks, works like a charm.

Sorry about the delay...but here is the db file.

Sorry, it is not doing anything

I tried the code but it is not working. Should I place the code on another event? It is currently on after update of the amount text field. The amount entered is not being displayed in commitments or expenditure. How can I bind the information to the field and save it to the table?

Here is the scenario: I have a table Finance with the following fields Table Finance Id ProjectNo Type Amount Commitments Expenditure Type is a combobox with the selections PR, PV, SR, PDN This information is displayed in a subform 'Financials' with linkage to the main form via projectno and...

Ok, I Got it to work. I removed the Distinct in the SQL query

I have a main form with project information and subform with financial information for each related project. Every time I try to add a new record, I get the error message "field cannot be updated". I click ok and it appears again, this continues three times after and then disappears when I...

Hello, I have a main form, "frmProjects" and a subform, "subformFinancials". It is used to track project information. This form is to view, edit and add new records. The user is allowed to add new financial records on the subform. However, there is a purchase type field "cboType" which the...

Ok, I'll try again, ensuring that the syntax follows what you wrote.

I tried both but I'm still getting the error message. I have no code on the OnCurrent and On Load event of the main form, "frmEditProjects". On the subform "frmPictureExample", I have the stated code on the onload event and on the oncurrent event, here is the code: Private Sub Form_Current()...