I just want to ask on how to retrieve a query result when i filter a field on one table that has a value base on relationship of other table.
The value of table2 gender is based on table 1 via relationship created in ms access.
when i quey something like:
rs.open "select & from table2 where gender='" & cbgender.text & "'",conn,adopenkeyset,adlockoptimistic,adcmdtext msgbox rs.recordcount
where cbgender.text =depending on user selection(Male, Female)
I just wonder whats missing right here because the recordcount is still 0 even if there is a match in a query.
Thank you for giving time..