A
admin
I added a table to my Access 02 back end and now want use it as a look
up for an existing table. Since I need to update all my users
backends, I need to do it via vb.
Existing tables:
tblAircraft
AircraftID
AircraftType
Engine - Lookup : combobox, value list, "piston, jet, turboprop"
tblEngines
EngineID
Engine
I want to change tblAircraft.Engine row source type from value list to
table/query and add the sql statement to row source.
If it can't be done via vb, if I change the input form to look up the
engine table will that over ride the value list? I'd still have to
modify the Limit to List.
Thanks for the help.
Mark
up for an existing table. Since I need to update all my users
backends, I need to do it via vb.
Existing tables:
tblAircraft
AircraftID
AircraftType
Engine - Lookup : combobox, value list, "piston, jet, turboprop"
tblEngines
EngineID
Engine
I want to change tblAircraft.Engine row source type from value list to
table/query and add the sql statement to row source.
If it can't be done via vb, if I change the input form to look up the
engine table will that over ride the value list? I'd still have to
modify the Limit to List.
Thanks for the help.
Mark