Search results

Help. I am certain this is easy, and I just have a syntax error. I have a subform that I'd like to filter with a command button. The subform has a calculated field txtOpen with the value: =IIf(IsNull([DateToContractor]),"Open","Closed") I am trying the following code, with no luck...

Thanks! Works like a charm.

I have a form with 2 combo box and 3 subforms. I want the subforms to display data based on queries using criteria from the combo boxes. I am using an after update even on the 2nd combo box. I want to use the queries as I would like to use the subforms on different main forms. The...

Yes, I use a subform. The 2 key fields are needed because I have multiple jobs that I am tracking.

Thanks! I like that idea, however, most submittals will not need a resubmittal, so most of the PreviousSubmittalID_FK would be blank. Not the worst, I guess.

I have a database that I am using to track submittals on construction projects. I am struggling with how to handle resubmittals. If the submittal is not accepted, there would need to be a resubmittal related to the original. Attached is a shot of the relationships. The Status field is...

Thank June - works like a charm!

Thanks James - I'll try something like this tomorrow at work. Galaxiom - The subforms are not linked - they are all subforms are all subs to the main form that is unbound. It's not ideal functionally, but I like the look.

Thanks James. Update would work, except there are some cases where I am not updating data, just looking at it going from one record to the next. Thus no update.

Thanks Galaxiom for the quick response. I can't figure out how to code what you are suggesting - google search did not help me either. Andy

Working in Access 2010. I have an unbound main form that I use to recall data from tables. I have 4 subforms on the from in a tabcontrol. The subforms data are all linked properly. I have the following code to requery 3 of the subforms when one of the other forms changes records: Private...