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
LVL 1
JustinWAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Rey Obrero (Capricorn1)Commented:
can you upload your app and explain what you were trying to do..
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.