how use dlookup to update table

[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

 

[Allen Browne]

You cannot use DLookup() to add a value to a table.

If I understand, you are trying to add an item to the combo's RowSource
table? If so, see:
Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html

The article gives 4 approaches.

 

[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.

 

[Allen Browne]

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

Please try again: The page should be there.