This is the expression I compiled, but I am getting a syntax error.
if(forms!sub_form_1!path_length = forms!sub_form_1!sub_form_2!form.path_length, True,False)
Where f1 = sub form 1
f2 = sub form 2
field 1 & 2 = path_length
Although I've got my database up and running, I don't have much experience with Access yet (I'm also having to use Access 2002). Can you give me a more detailed explanation if possible. Thanks for your patience.
I have a form with 2 sub forms which have identical fields from different records. I want to use conditional formatting to indicate a mismatch between 2 of the identical fields. I have been told I should use [NewField] <> [OldField] but I don't know how to complete the syntax. If I call the...
Thanks for your quick response. On my main form I have two subforms called "N-Band_Antenna_Distance subform" & "N-Band_Antenna_Distance_2 subform". All the fields on these 2 forms are duplicated. I want to compare some of these fields, for example Text Box: "SPECTRUM_LINK_ENDA_ANT_CENTERLINE"...
I've put together a DB that consists of a main form and 3 sub-forms. Two of the sub-forms come from a query that is derived from 4 databases via ODBC. These sub-forms show engineering data and I want to be able to highlight fields in the new build form that differ from the old build form. I've...
Hi
I work in telecoms, Mobile Networks & live in Essex. I've put together a simple DB to replace an "awkward" one we were using for years at work and just learnt what I've needed to do each step, so far so good. I'm stuck with an old 2002 version but it does way more than I'll ever understand...