how use dlookup to update table


J

jack

hi everybody

I come from china. Firstly,I'm sorry. My english is not good.

I have a question about dlookup

I have two tables. One table (table1)only have two fields "file name" and
"file ID". Another table(table2) also include field "file ID" and "file
name". table1 have many records. I want to accord record from table1 to
update table2 when table2.file name=table1.file name. I design a form to
input table2, there is a combobox in the form that I hope its list from
table11.file name,when I choice a file name another textbox value will
accord "file name" changes "file ID". After that accord combobox.value and
textbox.value update table2. I want use dlookup to do this work. but it
didn't work.

can you help me! thanks a lot
 
Ad

Advertisements

J

jack

Allen Browne
Thank you for your help.

I Try to add an item to the combo's RowSource from table1. It worked.

I want use Dlookup() to update a textbox.value according to combo's.value,
than update table2 according to textbox.value. these steps not work.

I want to browse http://allenbrowne.com/ser-27.html, but it isn't
available.
 
Ad

Advertisements


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