selecting Sub-Form data from two inputs

[techexpressinc]

almost that simple - the user does not pick the data to be loaded - the plainid on DB-a needs to pick the data to be loaded

[ajetrumpet]

so isn't the issue then, connecting to DB, then to either DB-B or DB-C, depending on what you need?

I can't really help with that, because I've never connected to multiple back ends at one time.

[techexpressinc]

I have an approach; I will post more on Monday.

The sub-form will have an event (vb-code that is) with the open.

code <>
DIM rsPlan DAO.Recordset
Set rsPlan
db.execute qry_DB_A
if rsPlan EOF
db.execute qry_DB_B.
code <>

I am novice at VB coding so this will good.

Russ

[ajetrumpet]

very nice.

and you're a novice in vb, but you've got a website and a successful business? hmm. okie dokie!

[techexpressinc]

it worked out just cking for nulls and using the other field.

the weird thing was it need a 3rd table in the mix with the common key

i just could not pass it the parameter plan-id to the 2 select from tables.


I do not do much of my own business from techexpressinc.com anymore.

I work full-time at lfg.com as a business logistics consultant - see my profile at linkedin.com - russell neuman - fort wayne indiana

Thx for all your help

Russ