I have dozens of small and infrequently used tables (remote SQL views) that I need a quick way to develop an ADD form. It does NOT have to be pretty.

I thought of haveing a PRG that is called with file number
Then a Case statement to open correct table.

I hoped I could use only one generic ADD Form.
Open the database before I call the form.
Append blank at form load
Use EDIT command to show fields (this is a new record and not yet updated)
Put two command button at bottom Save & Cancel
Save has a tableupdate(), Cancel has Tablerevert()
Then thisform.release

YES, this is crude but quick to build.

Question: on EDIT command, can I put it on a Form and can I limit user to editing just that one record?