Search results for query: *

Hello Program Error...thanks you for your suggestions...I was able to get it working!I really appreciate your help. The datapigtechnologies link also helped me out greatly.

Hello...I replaced my DLookup with the DLookup you supplied and the function does not work anymore. I am still at a loss on how to make the DLookup data show up on my main forms table. thanks!

Thanks, if I am understanding you correctly, I can put this code in one of the events for the field in my form that has the DLookup function in it? So lets say in the "On Update" event, this code will run and input the data into the table I specify in the code?

Hello genoman, I would love to try the SQL insert or UPDATE statement, however, I am new to access and I am not where to put the code...do I put it in the DLookup statement or do I put it in the dispatch table design itself? Thanks!

Thanks for your response TheAceMan1...below is what I have in a field on the dispatch orders form to lookup the city of the Shipper that I select form a combo box that I have on the form. I have two tables in my database..Shipper and Dispatch Orders. Is there anyway to get this data that I am...

Hello. I am using the DLookup function on my form to pull data from a table in the database, however, the data that is pulls does not show up on the databases "main table" from the form. How can I make the DLookup data show up on the main table? Thanks!