Recent content by jaffar2000

I connected back the TextBox to the original field from the Table. I added the code. Gettign a complie error: Argument not optional.

Could you please elaborate more on what and where should I do with the DLookup function, the relevant field and the form??

Thanks. Can't see how to combine the DLookup with the need to save the data as explained in the link. I guess my need here is much bigger with less knowledge on my side. I appreciate your help very much. J.

Thanks, worked fine, the DLookup in the field in the main form takes the value from the field in the sub form as required however...since I'm putting the DLookup in the textbox of the field, as u suggested, the source of the field is no longer the record from the main table so any value my field...

it can be the id or the date, as long it is the last record that has statu = close. e.g: if RiskPlan1 = close and also RiskPlan2 = close and RiskPlan3 = open, then data is taken from RiskPlan2. if RiskPlan1 = close and also RiskPlan2 = close and RiskPlan3 = close, then data is taken from...

Table1 - Risks (the main form). ID Name Probability Severity Score UpdatedProbability 1 risk a 5 5 25 ......... Table2 - RiskPlan (my sub form) ID RiskId Name ExpectedProbability ExpectedSeverity Score Status...

Maybe my explanation wasn't clear. Here is an example: Risk number 1 in Table1 has 3 mitigation plans (plan 1, plan 2, plan 3). Each plan has an id, a date, a status and another number field (call it number2). Same for Risk2,3 and so on... The user fills in the data in the above number2...

ok this might be complicated. Background: Risk Management program to write the risk and its contingency plans. long story short - I have Table1 with fields: T1_ID (pk), Number1. I have Table2 with fields: T2_ID (pk), Number2, Date, Status (open/close values), t1_id. The two are connected...

Hi, I'm trying to add Items to my switchboard and I keep getting an error message whenever try to open the pick-list to select the specific form or table I'd like the command to open. The error is: "FillLstArg may not be valid setting for RowSourceType property or there as a compile error in the...

Had help from another place and found the problem: My file is located on a shared folder so I needed to set the location as trusted: "Code does not run in 2007/2010 unless your database resides in a folder that has been declared a “trusted” location."

Those are 2 separated fields with no connection between them and both do not have a default value.

Status is a combo box (drop down list) field with text data type.

not working. I wrote the code in the BeforeUpdate. I get nothing.

Why the wrong event, don't have I have to check the status after it was updated? Can you point me to the correct solution?

No. I even tried to make it more simple but not working for me. Private Sub status_AfterUpdate() If Me.status.Value = "X" Then MsgBox "you must supply the apply date" End If End Sub What did I do wrong here? Suggestions?