Writing the 2nd column of a combo box to a table

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




Hello I have a quick question. I have a combo box bound to a table that
grabs two columns, Product name and Product ID. I have hidden the
Product ID column on the combo box.

When the users selects the Product name,fills out a few other fields,
and hits add, I want only the Product ID and other fields (and NOT the
product name) written to a new table. I'm having problems because the
combo box is already bound to the first table that i got the info from.
Any ideas?


--
sushi155Posted from http://www.pcreview.co.uk/ newsgroup access

.



Relevant Pages

  • Re: Writing the 2nd column of a combo box to a table
    ... Using the column property, you can obtain the Product ID. ... > grabs two columns, ... > and hits add, I want only the Product ID and other fields (and NOT the ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Matching final occurance of a string in text
    ... > I need to substitute the final 'errors' out of the string leaving me ... as it grabs the first 'errors'. ... Anno ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: Strip off / Delete all attachments by age
    ... >> My understanding is that you can export based on attachment name, ... >> it grabs the entire message. ... There are also expensive archival solutions. ... Prev by Date: ...
    (microsoft.public.exchange.admin)
  • Re: for the Pogues fans
    ... when someone grabs it. ... I am very shaky with the binary stuff... ... (or cookies!) ... Prev by Date: ...
    (rec.music.artists.springsteen)
  • Re: Tommy
    ... BitTorrent tracker repository for grabs of UK TV programmes. ... Prev by Date: ...
    (uk.rec.motorcycles)