I am new to VBA and Access but I am getting through my first program.
I have reached a part where I need some help. I have a recordset that looks at a table in my database. I am using Access 2007. I am checking a field called Gauge that is a text field. I am checking for different characteristics and then populating three fields with the appropriate values. I am stuck because there is a case where the field contains a character string that will require me to lookup the information in another table. If I see the characters GA in my Gauge field, I need to find the values for that identifier in another table called tblGauge. To make matters worse, I need it to look up another field in the original table to find the right value. I am using a Do While loop to go through all of the records and update. I am attaching the code to this post for reference. The highlighted line is where I need the help. I put a select statement together that describes what I am looking to get out of the system.
If I need to provide any other information feel free to let me know. I am new to Access so please be specific in your requests.