If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing table field row source
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 |
#2
|
|||
|
|||
Changing table field row source
It is not elegant, but I fixed it by brute force. Added EngineID
field, ran update sql to fill in the fields then deleted Engine field. |
#3
|
|||
|
|||
Changing table field row source
It sounds like you are trying to use a lookup data type field in a table.
This can cause you (and your users) considerable confusion. Lookups are great, but they work much better in forms than in tables. By the way, when you say "update all my users backends", the implication is that you have multiple users, and that each user has a separate copy of the backend (the data store). A common multi-user design has a SINGLE backend and multiple copies of the frontend, one on each user's PC. -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|