How to check if two objects have the same property values

[JONeill]

I'm trying to avoid a complicated if statement so, I'm trying to find an easy way to compare the property values of two objects. Not the same reference but the values. There's gotta be a way to do that. Thus far, I haven't found anything but Is and IsNot operators.

 

[wist]

can you give us an example?

 

[JONeill]

So, I'm checking to see if a user has made any changes during an edit on a form. To fill the form, I get the chosen record out of the collection and place the values in currentRecord. I then check that against the form values to see if they are different. If they are, a message box pops up asking for confirmation when they want to cancel or exit.

I'm currently doing something like this...

if tmpRec.LastName = currentRecord.LastName And _
tmpRec.FirstName = tmpRec.FirstName And _

so on and so forth...

What I'd like to do is something like this...

if tmpRec = currentRecord then

I'm getting an error when I do that. Something about not supporting the property or method

 

[Norie]

Are you creating an object for the values on the form?

 

[JONeill]

Yes. The tmpRec is local to the sub but the currentRecord is global to the form.

 

[Norie]

I know you can check for object 'equivalency' using the Is operator but I think that only works when you have 2 separate references to the same object.

 

[JONeill]

I haven't seen anything that allows you to check properties in one statement either. Seems there should be a way to do that. I'm not even sure you could write something that does that since you can't traverse through an objects properties unless you know them in advance.