Search results

That works perfectly, thank you and apologies for the confusion/lack of info.

Thanks for all the replies but I'm still struggling to get this to work so I've attached a redacted version of my actual db. On the Update form when a value is input in DocID textbox, this value is searched in DocumentID column of DocT table and the respective document name from the second...

Changing the semi-colon to a comma stopped the syntax error but...I now get #Error when in form view in the box I entered the code and it seems to have locked up the database now and I can't close it. Ooops!

No problem thanks for getting back to me about this. I keep getting an invalid syntax error when using the above. Maybe I've edited it wrongly? I've changed the code to include the names of my elements but not sure if I've done this correctly. Also, not sure what the Nz is and the final [A]...

OK, thank you

That's where I'm getting stuck unfortunately. Very new to Access and queries are something I'm struggling with. How do I link the query to the result textbox? Totally lost sorry.

I have a table with 2 columns and in a form I have 2 textbox fields. When I input a specific value in one of the textboxes I want to automatically look up the value I've input in the first column of the table and populate the second textbox with the corresponding value in the second column of...

That worked perfectly...and it was easy. Thanks so much CJ. :)

Hi I'm very new to access and have a question about an issue I'm finding difficult to resolve. I've created a basic database and within it I have a table, a form (for input) and a split query form for searching for records. However, I want users to be able to input on the form part of...