Re: DBLookupComboBox question


"swansnow" <schultz@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1130421820.674182.196270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> For the sake of example, the table I'm reading from is table1, and the
> table I'm saving to is table2
>
> I tried this:
> Datasource -> dsTable2
> DataField -> recordID
> ListSourse -> dsTable1
> ListField -> recordName
> keyField -> recID (from table1)
>
> The behavior I see is the combobox is populated properly, but when I
> select something, the edit part doesn't display anything. Table1 is
> active (as evidenced by the list being correct), and table2 is in edit
> state, so it should show up.

Is recID unique within table1?


.

Relevant Pages

  • Re: double data entry with msgbox function?
    ... loop through the fields in Table2 comparing each field to its corresponding ... Table1.Do you Wish To Edit One Of The Tables?",vbYesNo,"Field Values Don't ... <Code To Edit Table1> ... Need a month calendar or 7 day calendar? ...
    (comp.databases.ms-access)
  • relation problem between Mainform-Subform?
    ... Say that Table1 has ONE, Table2 has MANY side of the relation. ... I can edit any value in the tabular subform. ...
    (microsoft.public.access.formscoding)
  • Re: Tricky Visual Basic Code help...
    ... moves the current record into a new record in table2. ... this with a little VBA code and a couple custom queries. ... Set a "pushFlag" column in the record in table1 to a specific ... If a duplicate is not found, ...
    (microsoft.public.access.formscoding)
  • Re: Help needed with importing XML
    ... You could add a gratuitous identity column to #temp and use ... Those examples showed how to decompose arbitrary XML in multiple ... table1 and table2. ... But there has to be something in the relational schema tying table1 ...
    (microsoft.public.sqlserver.xml)
  • Re: 2 column pulldown
    ... Allen Browne - Microsoft MVP. ... these field heading names come from Table2 since it is a lookup and so ... Table1 of course only has a single column name ... fieldX from Table1 is pulldown revealing candidate values of Table2. ...
    (microsoft.public.access.forms)