We help IT Professionals succeed at work.

Unbound Continuous Form

Aaron Greene
Aaron Greene asked
on
824 Views
Last Modified: 2013-11-28
Is it possible to have an unbound continuous form?  I am trying to create an unbound application, but I am stumped on how I should deal with a form that should be unbound.  It is a list of work orders form.
Comment
Watch Question

I'm not sure what you mean

Where is the list of work orders coming from ?
CERTIFIED EXPERT

Commented:
'Is it possible to have an unbound continuous form?'
No. It's impossible.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
'Unbound Form' and 'continuous form' are basically and oxymoron ... doesn't really make sense.  If controls are not bound, then every row will show the same value for each respective control - assuming the control is somehow populated.

mx
I have a feeling you mean an "Un-Linked" continuous "subform" in which case the answer would be yes. However the form must still get it's data from somewhere, either a table or a query etc.
Database Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Time for author input here ...

mx
Aaron GreeneProgrammer

Author

Commented:
What I'm trying to do is to create a continuous form based on a recordset instead of a table.  I think the proper term would be a "disconnected ".  My first thought was to create the recordset and then fill a list box with the data from the recordset.  The problem that I ran into was that my recordset had more fields in it than I had space for in my control.  Now, I'm thinking that I need to create a temporary table from the recordset and then base the form on that.  I'll have to control changes to the data another way.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Purvis is your guy for disconnected recordsets ... in fact, he just published an Advisor article (two actually) on the subject :-)

mx
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
And am well behind on planned subsequent pieces... man, but for more time!

What version of Access are you using (and deploying to)?
As this all gets much better *after* Access 2000 (FWIW it only first becomes at all possible in 2000 - but the options grow with 2002 onwards).
For example - you can then bind your listbox to your recordset, and then the form to that same recordset (a more efficient methodology than even Access employs internally - hitting the db only once for the data of listbox and form).

A (hopefully) nice simple example of a disconnected recordset / continuous form operation is in the example I pointed you to previously.  (The "Orders Recordset" option - which opens frmOrderUnboundRecordset).

(There's also the local table variation too - which uses larger scale bulk SQL executions to move the data, which I'd really recommend in Acc 2000 too).
Both examples show retrieving and updating data.
(There are nuances that exist on the techniques offered - variations a plenty).

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.