Recent content by trigirl67

So how would you incorporate the Dlookup and the if statement?

How do you do an open recordset? There is a form which is linked to a table and in the table there is a field called completion date that is updated from a different form. So I want to update a field [Request Type] based on an ID field and if the completion date is > 6 months old, then update...

How do you make certain fields "required" to be completed before exiting?

Thank you but what if the completion date comes from a table not a field on the form?

If I want to say...If the [Completion Date] > 6 months old, then do something...how do you say in VBA code?

I am trying to compare 2 dates, see if one is less than the other, then do something. If [Min Request Date] < Now Then Me.[Request Type] = "New" Else Me.[Request Type] = "Old" End If BUT I always get "Old" no matter what the min Request Date is. Does the Min Request Date need to be...

The first combo box has the words "id" and "name" to choose form, the second combo box pulls a list of either the names or ids and then the 3 box SHOULD get a date based on either the name or id chosen. I do not know how to do the 3rd query because when I pull date, id and name into the query...

I am not a pro yet in VBA...need a little more assistance please

Thank you for your response, but I have not done a continous firm before, Can you walk me thru the proscess you suggested pls

I want to have a user search the first combo box of a form and then the results of that box give you choices in the second combo box (that part I have working ok), then I want the form to autopopulate form a table for the remaining fields on the form. Here is what I have...