Saving Form Design

[Scotts]

It seems the one big thing lacking in MS Access is the ability to save a form design and use it as a template when using the wizard. I like to set my fields all in one column and extended to edge of Form.

Unless this is possible, I have elected instead to 'Save As' the Form as my next form project. However, how do I assign a Table to a Form and Form to Table?

 

[Joan Wild]

It seems the one big thing lacking in MS Access is the ability to
save a form design and use it as a template when using the wizard. I
like to set my fields all in one column and extended to edge of Form.

Create your template form and save it. Go to Tools, Options, Forms/Reports
and replace 'Normal' under Form Template with the name of your form.

You can also open your from template in design view, and go to Format,
AutoFormat. Click on Customize, and you can 'create a new format based
on...', which will be available when you run the form wizard.

Unless this is possible, I have elected instead to 'Save As' the Form
as my next form project. However, how do I assign a Table to a Form
and Form to Table?

In design view of the form, show the properties, and change the RecordSource
property on the Data tab.

 

[Steve Schapel]

Scott,

There is some good information on this here...
http://members.iinet.net.au/~allenbrowne/ser-43.html