Combo Box - After update...

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

Hello...

I want to update a field on my form with a value that is in my combo box
list. So for example, I have three columns I have chosen and viewing in the
combo box:
id (this will get stored in the product_id field in the
record source table of the form)
name (this will be displayed in the combo box)
verison (i want this field to be populated from the third column
in my combo box after I select the right product)

Is there away programmatically that I am able to do this without doing a
DLookup?

I am using Access XP.

Please advise...

Cheers!
Brett


.

Relevant Pages

  • Re: DLOOKUP VS. COLUMN(N)...
    ... MS articles generally point to the DLOOKUP option... ... the form's data in its record source query. ...
    (comp.databases.ms-access)
  • RE: "Invalid use of null" when opening a form in Access 2007
    ... Do you have any fields with DLookup() or another domain aggregate function in ... the record source? ... I have created a blank database and ...
    (microsoft.public.access.forms)
  • Re: Referencing a type w/o included source?
    ... code (caller and recipient)? ... Brett ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Change Value in Different Table
    ... By definition, DLookup is read-only: it can only retrieve a value, not ... To update, you either need to use an UPDATE query (which you can, of course, ... > value of my field in XYZ Form I want the value to ... > (which is NOT my record source). ...
    (microsoft.public.access.formscoding)
  • Re: walking on bwperim()
    ... Can you try this explanation again? ... > felix. ... Brett ... Prev by Date: ...
    (comp.soft-sys.matlab)