Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    25

    Question Unanswered: Finding a difference

    Hi,

    I have a subform within a form. The form contains data that is linked to a query which is linked to an external table through ODBC. The subform is linked to a table where it contains data that is entered manually.

    The subform and form have the same fields, but what I am trying to do is find where the data within the subform and form do not match. Basically, I am thinking of a cell within the subform to be highlighted when it doesn’t match the entry within the query data which is on the form.

    Any help would be much appreciated, thanks.


    Regards

    Phil

  2. #2
    Join Date
    Jul 2003
    Posts
    48

    Re: Finding a difference

    Write some vba code to compare each cell from Main form to sub form, if the contents are different then set the backcolor , i.e

    if frmMain.Text1 <> frmSub.Text1 then frmSub.Text1.BackColor = vbRed

  3. #3
    Join Date
    Jul 2003
    Posts
    25

    Question Finding a difference

    Any chance that you can write the code for me as I do not know much about VBA programming.

    Much appreciated



    Thanks



    Phil

  4. #4
    Join Date
    Jul 2003
    Posts
    25

    Question Finding a difference

    Hi,

    I have tried to see if the back colour works manually i.e. changing it in design view. But when I switch to form view the colour does not show up even thought it does when I am in design view of the subform. Any solution, thanks

    Phil

  5. #5
    Join Date
    Jul 2003
    Posts
    25

    Exclamation finding a differnce

    another thing is that once a difference is found it highlights the whole colum rather that the specific cell - any soultions, thanks



    Phil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •