AboutBob Heifler Expertise ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS
Free Microsoft Access Tutorial Videos are available to you at
my web site. Fifteen years of Microsoft Access experience allows me to
answer most of your questions. Common question example files available
here.
Experience Microsoft Access
programming since 1994. Support for all versions.
Publications My Microsoft Access
articles are published at:DailyAccessTips.com
Education/Credentials UCLA GRAD, Member of Association of Database Developers
Awards and Honors AccessToExcel.com
has won several
shareware awards for assisting analysts in moving data from MS Access
to Excel.
Question Two questions:
I would like my subform to look like an actual form, is this possible? It always seems to look like a table.
Also, How do I create multiple subforms on a page so that I can create a slick user interface so when someone chooses the following: Choose Area -> Choose Building in selected area -> Choose Room in selected building -> Room Information is displayed
Answer Ryan,
You can change the default view of the Sub Form to 'Single View'.
You might also want to redesign the form by moving the controls around so they look more like a single record data entry form. It's easier to just use the form wizard or auto form columnar. Do not select auto form tabular or auto form data sheet when creating your new sub form.
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS