Requery in a continuous form

[P_Henry]

Hi,

I have scanned through the forum but have not found an answer for the above..

How do I do a requery only for the combo box of a particular record in a continuous form?
To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all sub-sectors based on the value selected in the previous primary sector combo box.

When I do a requery using the following code,

Me.cboDACCode.Requery

all the records in the form get requeried.

All the field are bound field.

There was a similar post in the form but was not complete.

Thanks...PH

 

[seth_belgium]

Is it absolutely nescessary for the form to be continuous? The simpelest sollution would be to make it a single form, showing only a single record.

 

[dragginthru]

I came across this problem, im only a newbie so I chickened out and made it into a single form.

However for my purposes a continuous one would be better and avoid the confusion.

If there is a way this can be accomplished, it would be nice to know - experts...?

 

[P_Henry]

Does it mean that this is a limitation of a continuos form??-

 

[P_Henry]

Thanks Pat...I'll have a look.
Priya

 

[strikeuk]

If you search the samples forum, I posted a database that shows a technique for getting around this problem. I don't have a link handy. Just search the samples for posts by me. Make sure to limit your search to the samples section. I have quite a lot of posts here.

I tried searching the samples forum but i can't find any of your post. By any chance do you still have the samples? I really need to know how to do it.

Thanks

 

[johughes]

Pat - to save me distecting the fix in your sample. Any chance of giving the highlights on yiur design approach?

John

 

[Heather L]

Hi Pat,

Your posts on this problem are very helpful as I am experiencing a similar problem with my cascading combo boxes. However, I think this fix creates another problem for me.

Please refer to my post located at:
http://www.access-programmers.co.uk/forums/showthread.php?t=101001
There is also a diagram of the database relationships attached to the post noted above.

Just as I cannot get the parent/child links between the main form and subfrom to work properly when I link the Lessons table into the subform, I have the same problem when linking in the dancenames table and the songs table to PlanProgramDetails within the subform. Unfortunately, I think I need to pull these two tables in so the textboxes which cover the cascading combo boxes have words in them instead of just the primary key record numbers so that the information makes sense to the user. So, do I really need to link these 2 tables in or do I have something set up incorrectly in my tables or overall design? And, how do I get the linking field between the main form and subform to work right when there's more than one table underlying the subform?

Thank-you,
Heather