Property Name

Description

SQL

The SQL statement that is used to ‘populate’ all the controls on this form.

Ie.

SELECT * FROM CUSTOMERS

Caption

The ‘text’ that will be displayed at the top of this form. 

Ie.
Customer List

AutoForm?

Determines whether this form will automatically be displayed whenever this database is opened.
(NOTE:  This feature only works on the PocketPC device.  It does not function in Desktop Studio)

Back Color

The background color for the entire form.

Navigation Menu

Determines whether the navigation menu at the top of the screen will be displayed or not.

Close Button?

Determines whether the CLOSE button at the bottom of the screen will be displayed or not.

Data Mode

Determines what ‘mode’ this form will be opened with:

0 = Add Data
1 = Edit Data
2 = Read Only

Password

If a value is entered here, you will only be able to ‘edit’ this form again by entering the password.

Scrollbar(Horiz)

Determines whether the Horizontal scrollbar will be visible.

Scrollbar(Vert)

Determines whether the Vertical scrollbar will be visible.

Data Server

The remote server used to execute the SQL statement against.  NOTE: Use “---“ for Local Device.

Remote Index

The name of the ‘Primary Key’ field in your remote table.

Remote Table

The name of the remote table being queried.

Timer Enabled?

Determines whether the forms ‘timer’ will be enabled or not.  The forms TIMER allows you to execute code at predefined intervals.  Useful for refreshing data automatically, updating an onscreen clock, etc…

Timer Interval

The interval at which the timer-event will fire.  In milliseconds. 1000 = 1 Second.

Subform1

An SQL statement which returns a recordset that you can bind controls to.

Subform2

An SQL statement which returns a recordset that you can bind controls to.

Subform3

An SQL statement which returns a recordset that you can bind controls to.

Subform4

An SQL statement which returns a recordset that you can bind controls to.

Subform5

An SQL statement which returns a recordset that you can bind controls to.

Module1

Up to 32,000 characters of code.  May contain many different ‘subroutines’ which may be called from any other code in your applicaton.

Note:  Modules 1-5 are not specific to any one form.  Any code entered into any of these modules will be available from EVERY other form.

Module2

Up to 32,000 characters of code.  May contain many different ‘subroutines’ which may be called from any other code in your applicaton.

Note:  Modules 1-5 are not specific to any one form.  Any code entered into any of these modules will be available from EVERY other form.

Module3

Up to 32,000 characters of code.  May contain many different ‘subroutines’ which may be called from any other code in your applicaton.

Note:  Modules 1-5 are not specific to any one form.  Any code entered into any of these modules will be available from EVERY other form.

Module4

Up to 32,000 characters of code.  May contain many different ‘subroutines’ which may be called from any other code in your applicaton.

Note:  Modules 1-5 are not specific to any one form.  Any code entered into any of these modules will be available from EVERY other form.

Module5

Up to 32,000 characters of code.  May contain many different ‘subroutines’ which may be called from any other code in your applicaton.

Note:  Modules 1-5 are not specific to any one form.  Any code entered into any of these modules will be available from EVERY other form.

Event Name

Description

On Current

This event is executed whenever a new record is displayed.

On Add

This event is executed whenever a new record is ADDED.

On Delete

This event is executed whenever a record is DELETED.

On Open

This event is executed whenever a form is initially OPENED.

Timer Event

This event is executed at predefined intervals as determined by the forms TIMER INTERVAL and TIMER ENABLED properties.