JustinW
asked on
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
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
ASKER
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
the corresponding field in the table is gone.
I want to keep all fields in the table, but have controls for only 3
can you upload your app and explain what you were trying to do..
ASKER
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
thus, these are the only controls I want visible in the controls section.
Thanks,
-JW
DEV-APP.accdb
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...
you can also, set the Locked property to yes, to make them unEditable...
ASKER
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?
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?
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 ?
on the top section, you want to show 6 controls .. is this correct ?
so what is the problem with setting visible =false ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
sorry, late post
see this link
http://office.microsoft.com/en-us/training/create-a-split-form-with-the-split-form-tool-RZ010291967.aspx?section=5