Preserving Access Form Design Changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy - 26 May 2008 18:31 GMT

[Apologies if this is a duplication -- I am not sure if my previous message
was posted.]

I make changes to my Access database using the Tables, but enter data using
Forms. I like to redesign my forms.

However, it seems as if each time I make a change, I have to save the Table
as a Form, losing the design changes I previously made in my form. Is this
inevitable, or is there a work-around that does not involve programming, as I
am not a programmer?

I know some will say that I should think out the structure in advance, but I
find that I still end up making changes in the fields after I've started.

Thanks,

Reply to this Message

Wayne-I-M - 26 May 2008 20:04 GMT

I think (may be wrong) you are re-designing the "table" not a form

Create a new query based on a table (use the wizard if needed)
Go to forms
Select New
Select design view
The form will open
Right click the form (outside the grey area)
Open the propertiy box
In the data column select the source row
Select your new query from the dropdown list
Drag the fields into the design area
Arrange them as you want
Save the form with a name that means something
Like frmNames or frmLogistics, frmStaffMembers etc etc

Open the form in normal view and it should have saved and you will be able
to enter/view data in the table

Signature

Wayne
Manchester, England.

> [Apologies if this is a duplication -- I am not sure if my previous message
> was posted.]
[quoted text clipped - 11 lines]
>
> Thanks,

Reply to this Message