subform in a continuous form

[Guest]

Hi All,

We have a continuous form in which Order No.’s with customer information and
amount of the order are displayed. I wish to create a button or a plus sign
near the order no. where if the user clicks he can see the line items of this
order (which are stored in another table).

The problem is that Access is not allowing making a sub form in a continuous
form.

I wish to make the interface similar to this discussion group – when you
click on the plus sign on any thread you can see its contents.

Please note that I do not want to use datasheet view as the line items have
some buttons to some actions related to that particular line item only.

Could you please suggest any way around this problem?

I have a limited knowledge of access. Any clue would be highly appreciated.

Many thanks!

Regards
Avir

 

[Guest]

Use single form with navigation button to move from one record to another.
It's similar to continues form, but the only different that in single form,
each record dislayed at a time, with the ability to move around them

 

[sebt]

Hi Avir

The only way I can think of round this problem is to use a separate
popup form to show the line items instead of a subform. You'd have to
open it passing a WHERE clause in the OpenForm action to make the popup
form show only items for the currently selected order.
It's possible to position this form in its Open event so that it
appears directly below the currently selected order (you'd have to
calculate the screen position of the currently selected order in some
way).
Not a neat or easy solution, and a long way from what you're hoping for
- but as far as I know there's no other way of doing this in Access.

regards

Seb

 

[Guest]

Dear Ofer

Many thanks for your reply.
I am not sure if I understood your suggestion, if I make a single form with
navigation button, I am still able to see only one record at one time;
however I wish to see all records at same time and wish to expand related
subrecords of a particular record only.

A little bit more explanatoin migth help me a lot.

Thanks!
Regards
Avir

 

[Ron2005]

One way is to have a button on that continuous form or on say a
<dbl-click> of the order number to open another form that displays any
and all of the information you want that is based on a query that
selects only those records for this order (or whatever else is
necessary to make it get only those records.) if you use a button, it
can actually be someplace else on the screen.

Ron

 

[Roger Carlson]

The problem is that Access doesn't allow a subform to be embedded on a
Continuous Form. The following is one solution.

Have an unbound Main form with two subforms. The first subform has the
Continuous Parent Subform and the second has the Continuous Child Subform.
You synchronize the forms in the On Current event of the Continuous Parent
Subform by issuing a Requery for the Continuous Child Subform

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformInContinuousForm.mdb" which illustrates how to do
this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Dear Roger

Thanks for your valuable reply.

Regards
Avir

 

[Guest]

Hi Seb

Many thanks for your input. I guess I will have to make a sub form on the
right side of the order list to show the line items and its actions (similar
way as outlook 2003) or make a regular popup form.

Regards
Avir

 

[Ron2005]

Actually you can use a sub form on a datasheet view. IF it is a true
child form the subform will show up as a "+" on the form. When you
click it it will produce a dropdown ALSO IN DATASHEET VIEW of the items
that would be in a sub-child form.

 

[sebt]

True. But only in Datasheet view - not on Continuous Forms view.

 

[zwh]

test