
August 27th, 2004, 08:45 AM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Getting Access97 to Build my form for Me (using SQL)
I'd like some general pointers on this topic for me. What I want to be able to do is have Access draw a form (text input boxes, combo boxes and labels) based on the results of a SQL query. I'm planning to have the possible questions (ie: fields to be displayed on the form) stored on a table and have Access draw the form subject to the type of form chosen (via a SQL query along the lines of SELECT questions FROM questionstable WHERE formtype = complaintform ). The idea of this is to make the form easily updateable - if new fields are needed on a form all I need to do is add a record to the table, rather than manually redesigning the form.
Is this possible using Access 97 VBA only? Can anyone suggest some good sites (or threads on this site) that I might use as a resource? As I don't even know what I am trying to do is called (!) if anyone can even suggest some keywords for searching on, I'd appreciate it!
Many thanks.
|