GReetings all,

well, if i may be so ignorantly bold...i am a newbie and would like to broaden my undertsanding of forms...

I have set-up a bunch of tables and was thinking the next step was to move on to forms...

So i set one up and the email address field didnt show up and *not that i can remember the error* access didnt want allow me to complete entering the records ectectetc...

but anyhu, let me see if i am going along the right way so far...

a form can be used to input records, update and change or delete records as per form set-up...right?

But there must be more to it than that...like does one also use a form via web interface for instance? Or is it for within-Access use only and admin pruposes...

Ie how else can one manipulate the different forms *in the general sense* to interface with a web asp script or web form/reply?

So, yeah, what i'm asking is whether forms and queries are built onto in access for purposes other than in-Access manipulation/admin...and then generally speaking how so...?

thnx from the newbie...

Hi,
at the very beginning Access was used in a local network environment. You design a database (TABLES, QUERIES), developp an interface with FORMS (basically you can do everything you want with forms), and REPORTS. At first the interface can be powered by MACROS and when you get familiar with VBA you start to add some code. You put your application on a server so users have access to it (Client-Server application).

Then you may want to add an online version. It can be static HTML (your reports are converted into HTML) or it can be dynamic HTML (IDC and later ASP/VBScript). Everything you did in the C/S version can be done on the Web.
You will have an application server (Internet Information Server for example), a DB server (your Access tables) and the client (the internet browser). On an ASP page, when you click on a "submit" button it sends the .asp page to the IIS server, which runs ASP.DLL, it sends the query to the DB server, and send back to the client (you) a HTML pages with the results of the query.
With VBScript and ASP you can manipulate all kind of forms (InputBox, ComboBox, ListBox,...), exactly like your Access environment.
But the client never "talks" to the DB Server, just to the application server.

I don't know if what I am saying is clear or not. Ask more if you want. http://www.access-programmers.co.uk/ubb/redface.gif)

Erik