Subform mods not saving

[wayne dooley]

This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform
to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except
I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back to
the old way. Yes, I do Save - and Save... I've looked at it from several
angles and can't see what I'm doing wrong. I'm using Access 2000 and these
are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

[Allen Browne]

First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open it
in design view. Make a change, and save. Close and reopen. Did the design
changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...

This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a subform to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully, except I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back to the old way. Yes, I do Save - and Save... I've looked at it from several
angles and can't see what I'm doing wrong. I'm using Access 2000 and these are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

[wayne dooley]

Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but
then I tried a few changes and they still do not stick. I've developed in
about everything except Access so I'm new to it. Here are some screen shots
to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design
view; decimals are automatic on the last column, different headings, widths,
etc.. It looks like a plain old grid, as if the form is approximating the
design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have
used (and am used to) in, say, VFP. For this Access project, I definitely
selected 'subform' from the tools menu and dropped it on the form. But I
seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open it in design view. Make a change, and save. Close and reopen. Did the design
changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...

This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to
many relationship. I created a form to show fields from CUST and a

subform

to show those in SUBS. The 2 tables are related on SUBSNO, and the data
source for each is the table (not a query). It behaves wonderfully,

except

I can't seem to change the layout of the subform in design view. I make
changes and can see them in design view but in form view it reverts back

to

the old way. Yes, I do Save - and Save... I've looked at it from several angles and can't see what I'm doing wrong. I'm using Access 2000 and

these

are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

[Allen Browne]

access2.jpg indicates the subform is in Datasheet view.

1. Open the subform in design view.
2. Open the Properties box (View menu).
3. Set the Default View property (Format tab of Properties box) to
Continuous Form.
4. Click the SubsAmt textbox.
5. Set its Format property to Fixed Number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:_HCIb.705253$Tr4.1775366@attbi_s03...

Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but then I tried a few changes and they still do not stick. I've developed in
about everything except Access so I'm new to it. Here are some screen shots to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design
view; decimals are automatic on the last column, different headings, widths, etc.. It looks like a plain old grid, as if the form is approximating the
design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have
used (and am used to) in, say, VFP. For this Access project, I definitely selected 'subform' from the tools menu and dropped it on the form. But I
seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open

it

in design view. Make a change, and save. Close and reopen. Did the design

changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?
"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...

This should be easy. I have 2 tables - CUST and SUBS, which have a 1 to many relationship. I created a form to show fields from CUST and a

subform

to show those in SUBS. The 2 tables are related on SUBSNO, and the data source for each is the table (not a query). It behaves wonderfully,

except

I can't seem to change the layout of the subform in design view. I make changes and can see them in design view but in form view it reverts

back to

the old way. Yes, I do Save - and Save... I've looked at it from

several angles and can't see what I'm doing wrong. I'm using Access 2000 and

these

are native Access tables that were imported from Foxpro 2. 6 DBFs.

Help?
thanks
wayne

[wayne dooley]

Allen, that worked beautifully - thank you
wayne

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

access2.jpg indicates the subform is in Datasheet view.

1. Open the subform in design view.
2. Open the Properties box (View menu).
3. Set the Default View property (Format tab of Properties box) to
Continuous Form.
4. Click the SubsAmt textbox.
5. Set its Format property to Fixed Number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"wayne dooley" <sp******@must.die> wrote in message
news:_HCIb.705253$Tr4.1775366@attbi_s03...

Thanks for you message, Allen.

I was using a Single Form. I changed it to Datasheet and it looked and
acted the same. I did what you said and it looked like that would work, but

then I tried a few changes and they still do not stick. I've developed in

about everything except Access so I'm new to it. Here are some screen

shots

to illustrate what's going on

1) The form with subform in design view. The last column specified 2
decimal places and there is some space between the textboxes.
http://home.comcast.net/~wrdooley/access1.jpg

2) The form in form view. Here the subform looks different than in design view; decimals are automatic on the last column, different headings,

widths,

etc.. It looks like a plain old grid, as if the form is approximating the design view, or is simply not using it at all.
http://home.comcast.net/~wrdooley/access2.jpg

Originally I wanted a grid instead of a subform. That's what I would have used (and am used to) in, say, VFP. For this Access project, I

definitely

selected 'subform' from the tools menu and dropped it on the form. But I seem to have gotten a grid anyway. Any ideas?
thanks
wayne
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

First, uncheck the boxes for Name AutoCorrect under Tools | Options |
General.

Then compact the database: Tools | Database Utilities | Compact.

Now select the subform on the Forms tab of the Database window, and open

it

in design view. Make a change, and save. Close and reopen. Did the

design changes stick this way?

If not, what view are you using for the subform? Datasheet or Continuous?
"wayne dooley" <sp******@must.die> wrote in message
news:WArIb.80802$VB2.169419@attbi_s51...
> This should be easy. I have 2 tables - CUST and SUBS, which have a

1 to > many relationship. I created a form to show fields from CUST and a
subform
> to show those in SUBS. The 2 tables are related on SUBSNO, and the data > source for each is the table (not a query). It behaves wonderfully,
except
> I can't seem to change the layout of the subform in design view. I make > changes and can see them in design view but in form view it reverts back to
> the old way. Yes, I do Save - and Save... I've looked at it from

several

> angles and can't see what I'm doing wrong. I'm using Access 2000

and these
> are native Access tables that were imported from Foxpro 2. 6 DBFs.
>
> Help?
> thanks
> wayne