G
Gdw Vaganee
I have an Access2002 database consisting of 2 tables. Table1 has about 3000
old and new addresses, an address being a housenumber + street (where the
total address for a particular house has changed). Table 2 is old and new
street names (where only the street name has changed, but not the
housenumber), with about 200 records.
My form for Table1 is linked to a query which asks for the old address (the
old street and house number) and returns the new addresses (ie new street
name and new housenumber).
Is it possible to link this to a macro which automatically opens a form
based on Table2, when the Table1 query returns zero records. Secondly can
the macro pickup the street input from the Table1 query as the record
criterion for Table2 ?
Any help will be appreciated, hanks
Roger
old and new addresses, an address being a housenumber + street (where the
total address for a particular house has changed). Table 2 is old and new
street names (where only the street name has changed, but not the
housenumber), with about 200 records.
My form for Table1 is linked to a query which asks for the old address (the
old street and house number) and returns the new addresses (ie new street
name and new housenumber).
Is it possible to link this to a macro which automatically opens a form
based on Table2, when the Table1 query returns zero records. Secondly can
the macro pickup the street input from the Table1 query as the record
criterion for Table2 ?
Any help will be appreciated, hanks
Roger