I just started using access recently. My project has access as the front end and SQL server as the back end. Usually I would bind the form to tables/views from the SQL server. I couldn't do that with one form because I have to do some computation on some fields of this table based on the value user selected from a Combo Box. Is it possible to bind the form with a temporary table in the local DB? If so, how? What other alternatives can I use? Thank you!

You can still create a separate query for you combo box source and still bind the form the a table

After you have created a form or report, you can modify its source of data to include or exclude one or more fields, columns, tables, or queries (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.). Changing the record source will change the contents of the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.).



Jaime E. Maccou
Applications Analyst

Thanks for the reply.
Perhaps I should have explained my situation a bit more. I could not bind the form to a table in SQL server because I cannot display directly the content of a few fields. On the form there is a combo box from which user can select the unit type for Meter Consumption (for example: GJ, lbs for steam meter or ft^3, m^3 for water meter), and the form should refreash when selecting different unit. All meter consumption are stored in the DB with the standard unit. Also the cost column cannot be displayed directly either without some computation with the tax factor columns in the table. Please correct me if I am wrong, I feel that I will have to use a temporary table to load the data and do some manipulation based on the type of meter user select and the unit type user select.