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!

[June7]

A DLookup domain aggregate function can do a quick search of table. Access Help has guidelines on Domain Aggregate functions.