• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Show a Split form | Want table to have fields the Form Doesn't

I'm using access07, on windows 7.
I'm trying to figure out how to create a split form, where the table part of the form shows all fields, but the form part (the part wtih the editable text boxes) only has a select few.

Thanks,
-JW
0
JustinW
Asked:
JustinW
  • 5
  • 5
1 Solution
 
JustinWAuthor Commented:
but when I delete a control,
the corresponding field in the table is gone.

I want to keep all fields in the table, but have controls for only 3
0
 
Rey Obrero (Capricorn1)Commented:
can you upload your app and explain what you were trying to do..
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
JustinWAuthor Commented:
I only want the user to be able to edit FAVORITE_BOYBAND, and FAVORITE_FOOD;
thus, these are the only controls I want visible in the controls section.

Thanks,
-JW
DEV-APP.accdb
0
 
Rey Obrero (Capricorn1)Commented:
before anything else, did you try setting the visible properties of the controls that you don't want to see to NO?

you can also, set the Locked property to yes, to make them unEditable...
0
 
JustinWAuthor Commented:
Setting visible = false works; but doesn't remove it from design view.
My real table has like 58 fields the users want to see; and really only need
to be able to edit maybe 6 tops.

Any easy way to do that?
0
 
Rey Obrero (Capricorn1)Commented:
your users want to see 58 fields in the lower section of your split form .. is this correct ?

on the top section, you want to show 6 controls .. is this correct ?

so what is the problem with setting visible =false ?
0
 
Rey Obrero (Capricorn1)Commented:
if you are concerned with the space occupied by the controls you don't want to see

select them all, and set the height and width properties to a minimal values..
0
 
JustinWAuthor Commented:
Both correct,
it just makes development more cumbersome
If there's an easy way to remove them from the controls; that's awesome.
If access can't do it, that's fine too;

Was just looking for something a little cleaner
0
 
JustinWAuthor Commented:
sorry, late post
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now