table 1 has the following colums of interest (uniqueref,style,plu,rootplu)
table 2 has the following colums of interest (uniqueref, description, comments)
each table can have its data referenced by its uniqueref colum due to sharing mapped information. i am after somehow having a text box of which i can type a numeric(rootplu) and it then runs the query and the comments cell i can enter data and then save. the rest is just for reference to the end user.
if possible i dont want it to keep the connection during the person reading whats being shown and then waiting for the user input. (its only because the mdb can be edited from other sources and want to try my best to avoid deadlocks