Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    4

    Unanswered: Complex Access Issue?

    I hope this is a snap for someone out there. I have a form (tabular), which is built from a query. There are a few fields on the form, which I need to assign values based upon a combination of possibilities (using VBA). The problem is, that at best, if I want to get a value for one of the fields, it is the first value of the recordset. Let me give an illustration to make this a little muddier.

    Name Address State Zip
    -------- ---------- ------- -----
    John 112 Easy Street, #208 IL 23423
    Joe Bob 884 Redneck Blvd. AR 13413

    The address is a concatenation of two fields (Address1 and Address2). Above is what I would like to see, below is what I actually see.

    Name Address State Zip
    -------- ---------- ------- -----
    John 112 Easy Street, #208 IL 23423
    Joe Bob 112 Easy Street, #208 AR 13413

    I'm sure there must be an event that fires off when the details portion of a form does a "MoveNext," but I have racked my brain trying to find the event.

    Thanks in advance for the help!

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    That would be the Current event of the form.

    Dan

Posting Permissions

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