Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic form creation (not showing all controls in a form)

Status
Not open for further replies.
wvdw

wvdw

Programmer
Jul 31, 2000
20
NL
Hi all,

I have a subform that is based on a query. The user can select the fields he wants to see in the query from a selection list. Changing the underlying query is no problem but when I show the subform the not selected fields are visible as well and the value is set to #NAME (or #VALUE) in all records.
So my question is how I can change the view of the subform so that only the selected fields are visible. Or how can I hide the non-selected fields?

Hope somebody can help.

Thanks.
 
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
371
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
386
strongm
strongm
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
517
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
437
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top