listbox in subform to update table

  • Thread starter Dennis Kwa (singapore)
  • Start date
D

Dennis Kwa (singapore)

Hi all, I'm trying to insert values into a certain "table C" which have 2
columns and contained in a subform. column 1 is the primary key field, where
the value comes from "table A" autonumber field (thru' link master/child
fields). column 2 is the data, where the value is from "table B" primary key
which is also a autonumber.

i'm trying to implement this using a list box, and the row source of the
list box is a query to "table B" with column 1 bound and hidden so only
column 2 data will be shown.

Anyway, i am having trouble implementing this setup. Any recommendations?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top