Combo and list boxes

[Blair Greene]

i have list and combo boxes both link to tables, however the tables were generated in
the orginal creation and are only views which dont seem to have the same power as a
regular table... is it possible to link a
combo box to a table that I created, if so how... thanks

 

[Jack Cowley]

Open your form in design view. Open the property sheet for your combo box. Under the Data tab is a property called Row Source. Put your table name there. Be sure the Row Source Type is set to Table/Query.

[This message has been edited by Jack Cowley (edited 11-23-2001).]

 

[Pat Hartman]

Access does not directly support views. Are you saying that your tables reside in a non-Access database that does support views or are you using the term view to refer to a querydef? In an Access database (meaning that your data is physically stored in Access tables), querydefs and tables can be used interchangeably.

Changing the rowsource of a list or combobox to refer to a table rather than a querydef will NOT give you any more "power" and in some cases will even cause you more trouble.

 

[Blair Greene]

Thanks....
I was able to build the relationship between form/table with your advise...