Question FORM expansion

[nayaz]

Hi

I have data entry form that has say 10 fields. Depending upon the value of the 10th field, I may have to add another 5 fields so that user can enter data in it. One way is to dispaly all 15 fields and make the last 5 disabled until the response in the 10 field is positive and make the last 5 fields enabled. If I do this the next form carries the values from the last form, i,e. fields may be disabled if the form in the last update was done that way. Any easy clean way?
Thank you.

 

[boblarson]

Sounds like your data design is a bit flawed. You should not have to add fields like that, but you add RECORDS (rows) instead. What is it you are dealing with anyway?

 

[dbDamo]

See my post (#2) in this thread which explains how you can hide/unhide controls and change the size of the form depending on which controls are visible -

http://www.access-programmers.co.uk/forums/showthread.php?t=180821

This of course assumes that your fields already exist in the table/query your form is bound to. If you are attempting to 'dynamically' create new fields then as Bob suggested you have design issues.