Running SQL using IF ELSE statement

[guillermoftw]

Hi everyone,

I utterly new to VBA and the goal of my code is to have an IF ELSE statement look into a table in my access DB, find a particular value and then run a SQL query based off of that value. The column can have two different values which is either associated or related. So my logic looks like this:


public function abcd()
IF "column value = related"
DoCmd.RunSQL = "sql statement 1"
ELSE "column value = associated"
DoCmd.RunsSQL = "sql statement 2"

Any help would be much appreciated.

Thanks!

[jforbes]

Sounds like DLookup is what you are looking for:
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

[NeoPa]

If you're going to use DLookup(), which certainly makes good sense, then I'd suggest you use Select ... Case instead of If ... Else ... End If as it will then only need to run the DLookup() once.

As DLookup() is processing through a recordset it is not something you want to run any more times than necessary.