Recent content by AFKillbait

I am attempting to set up a search on one of my forms to allow me to skip straight to a specific individual, however when I use the search it goes to the record BEFORE the person I selected. The search code I'm using is the same I've used in a previous form, so I'm not certain why it does not...

Two letters were messed up in there... of all the silly things to miss. Thanks for all the help, it's working as intended now.

Ok, thankfully that gets rid of the major error. Now I just need to figure out why it's giving me the #Name? error.

So if I wanted this part: (DateAdd("m",12,[Training])<Date([RetDate]) to check to see if the training date+12 months is before their return date (RetDate) i need to separate the Date part of the expression from the [RetDate] part with a comma? I know with the Overdue part of the...

Tried moving things around a little bit, changing the Conference box to 0 to see if maybe I could rearrange it to work so that it looks like this: =IIf([Conference]=0,IIf(IsNull([Training]),"Not Completed", IIf(DateAdd("m",12,[Training])<Date(),"Overdue"...

Wow, you know you were looking TOO hard when... Thanks for that. However it is still giving me "The expression you entered has a function containing the wrong number of arguments."

So now that I got that previous one working I have a new issue. I now need the text field to base its date on both a checkbox and three date fields so that if the date in the text box [TrainingDue] is before the one in the return date field [RetDate] it will display the date they are leaving...

I figured it out. I just needed to add another IIf line to the current expression: =IIf(IsNull([Training]),"Not Completed",IIf(DateAdd("m",12,[Training])<Date(), "Overdue",IIf([Conference]=-1,[ConfDate],DateAdd("m",12,[Training]))))

Right now the Due Date field is an unbound textbox. It isn't actually saved to any table, it's just based off of a Completion date that is. The completion date is just a pure date field on a table. Would the AfterUpdate event overwrite the expression for the Due Date in the Control Source?

Currently I have a due date field that uses the following expression: =IIf(IsNull([Training]),"Not Completed", IIf(DateAdd("m",12,[Training])<Date(),"Overdue",DateAdd("m",12,[Training]))) I also have a checkbox that makes a date field become visible if checked. I am trying to figure out how...

I managed to work it out, just a few minutes ago in fact, by putting that into the Control Source for the text box. Works perfectly, thanks again. :)

That did it, thanks... Talk about a "duh" moment.

I have an If/Then statement in VBA for one of my forms, under Form_Current() that displays "Not Completed" in the due date box if the original date box is blank. If IsNull(Me.Field) Then Me.Field_Due = "Not Completed" Else Me.Field_Due = DateAdd("m", 12, Me.Field) End...

I input that into the expression builder for the field in the query and it came back with #Error. Am I supposed to be putting this into the code for the Report? If yes, which section? Still pretty new at this, so learning as I go.

I have a Report that pulls its values from a query. The problem I am having is that I need the query to display "Not Completed" if the value for the other field is empty, display a date (using: DateAdd("m", 12, [FieldName]) ) if there is a value, or show "Overdue" if the date in the original...