Recent content by znpnh

Hi, I have a table with an auto number primary key field, and then several other fields, Address, Unit, Owner. I created a form with a combo box that looks up the Address from another table and populates the three fields when you click a record. I have it set to store the first value, (Address)...

Thanks much! I'll take a look at that in depth this week!!

Hi! I have a table that contains about 75 fields. Each field is going to be a Lookup field that will allow the user to enter multiple values. This is for a home inspection service. So the first field name will be ExteriorShingles. The user clicks the dropdown arrow, and is allowed to select...

I kept trying and even deleted the fields and started over. I saw a related post to this one, and used the expression in an on update in VBA, and it worked perfectly!

I took a look at both fields and they are both date fields. My form is based on the query, but the NextInspectionDate is auto filled from the expression in the query. Works just fine with a regular field, but not an expression. I'm totally stumped.

Hi, I created a query with one expression field that updates a user inputted date field on a form. The expression adds a certian amount of time to the field (usually six months) so I know when the next inspection should take place. Everything works great except when I put a parameter in the...

Thank you so much! Your expression worked perfectly. I added it to a query. I beg the question, why aren't you supposed to add a calculated field to a table? Just trying to learn the proper way of doing things. Thanks!:D

Hi All, I'm somewhat of a beginner when it comes to VBA, and I don't even know if I need VBA for this one. I have a form that contains three fields, LASTINSPECTIONDATE, FREQUENCYOFINSPECTION, and NEXTINSPECTIONDATE. The FREQUENCYOFINSPECTION is a combo box containing only three choices; "one"...