Re: combo box lookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Tracy

Both "Name" and "Date" are reserved words in Access. You will probably end
up confusing both yourself and Access if you keep using these as field names
(or have I misunderstood?).

Without seeing the code behind the AfterUpdate event on that combo box,
there's no way to tell how it is returning the "John Smith" record, or how
the date value is related.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Tracy" <Tracy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:256956D6-03D0-4A6F-8940-AC97ABAAB1CB@xxxxxxxxxxxxxxxx
My form is to track time worked by Name and Date.

I have the Combo Box drop down showing Name and Date, but when I select a
choice in the menu (ie: Column 1 Smith, John Column 2 05/01/2006). It
calls up Smith, John record but the date column does not correspond with
the
record that was called upon.

Is there a way to make this selection using 1 combo box, or do I need to
do
it with 2.

Thank you
Tracy


.

Relevant Pages

  • Re: Proper way to both display and save text data in consistent format
    ... > the AfterUpdate event of the appropriate control on a form. ... > To convert text to Proper Case, i.e. john smith to John Smith, use: ... > Be aware that the above will not correctly store some names, ... > MacDonald will become Macdonald, O'Brien becomes O'brien, etc. ...
    (microsoft.public.access.gettingstarted)
  • Re: Format Code
    ... a name entered john smith would be viewed as John Smith. ... Somebody very kindly sent me the following code to use afterupdate event but ... Then display its Properties ...
    (microsoft.public.access.formscoding)
  • Re: The *est Doctor Who episode
    ... Trool on john smith, and here the above is proof that you troll. ... which it was obviously a succubus knocking on the cabin doors trying to ... If he found Midnight confusing, I'd love to know what he made of some of the ...
    (rec.arts.drwho)
  • Re: Sitecom Homestation
    ... John Smith wrote: ... confusing. ... I.e. which newsreader does actually do this, ... Stone-age tin used to do the former, ...
    (comp.security.firewalls)