Continuous Form

  • Thread starter Thread starter Jack Wuelf
  • Start date Start date
J

Jack Wuelf

Hello
Is it possible to have a form that is similar to a
continuous form but using unbound text boxes eg: once the
first record is installed another set of text boxes open
for record 2 etc and then a button is used to enter the
data into the table?
Thanks in advance
 
Jack Wuelf said:
Hello
Is it possible to have a form that is similar to a
continuous form but using unbound text boxes eg: once the
first record is installed another set of text boxes open
for record 2 etc
Click to expand...

Yes, in fact the above is how ms-access works by default.

and then a button is used to enter the
data into the table?
Click to expand...

Hum, nope..that is going to be a real pain to code..but ms-access does the
whole process without needing a button anyway.

I might be misunderstanding your question. However, your continues form can
NOT be un-bound, as that don't work. Any reason why you can't use a bound
form?

Here is some screen shots and ideas of what continues forms look like:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
 
Is it possible to have a form that is similar to a
continuous form but using unbound text boxes eg: once the
first record is installed another set of text boxes open
for record 2 etc and then a button is used to enter the
data into the table?
Click to expand...

Almost anything is _possible_ with enough time and effort, but my answer
would be "Not easily... you'd have to do everything in code, including
manipulating the visibility of previously constructed controls, populating
them with data, moving the data as you 'navigate' through the list, ... "

Continuous forms are intended for bound forms. Frankly, I've used Access
since early in the days of version 1.0, and can't think of a time that I've
ever found it needful to have an unbound form for manipulating data. In the
long run, it's simpler to learn "the Access way", work with it using bound
forms, and not have to re-implement all that functionality that's already
provided in bound forms.

I use unbound forms for menus, for data selection to display or print, and
instead of MsgBox when I don't want the message to be modal, or when I want
it to close itself after a period of time, and for occasional other
"miscellaneous" uses, but not for displaying, entering, or editing data.

Larry Linson
Microsoft Access MVP

Thanks in advance
 
Back
Top