Yes it is possible. It is usually better to set the form's record source to a
query than to a table.
Examples:
Duane Hookom has a sample survey database "At Your Survey" at
http://www.rogersaccesslibrary.com/f...pics.asp?FID=4
This fully functional application uses a small collection of tables, queries,
forms, reports, and code to manage multiple surveys. Users can create a
survey, define questions, enter pre-defined answers, limit to list, report
results, create crosstabs, and other features without changing the design of
any objects.
Allen Browne has some sample databases at
http://allenbrowne.com/tips.html#Application
Just look for links that are tagged with sample Database in the descriptions
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Chiki wrote:
Is it possible to Display data in the form using the tables as the back-end
database.if so ,please provide me any examples....i want to study
them..........
thanks in advance.