Combo boxe in a continuous form

[L'apprentis]

Hi everybody,
In a continuous form, If I use a comboboxe with a criteria looking up a field in the same record, it seems that the combo boxe only looks up the value of the firsrecord, Iam not sure I understand why?
I was wondering if it there was any method to be able to use Cascading combo boxe in a continuous form.

 

[RuralGuy]

Continuous forms are really just multiple copies of the same controls. Each control needs to be bound to a field for it to function uniquely. Out of curiosity, why would you want to look up a field in the *same* record?

 

[L'apprentis]

Well, it's a bit complicated to explain but I'll try:
I have drawings for various item and each item can have 1 to 30 drawings. I Wanted to use the continuous form to select a specific drawing:
1)You select the item
2)You select the drawing
Then you can add command button in the continuous form to go to the specific Drawing.

 

[RuralGuy]

Truthfully, it sounds like a design problem. I would think the drawings would be in another table with the item number PK as the foreign key. The drawings would then deserve their own SubForm which you could display right next to the SubForm with the Items in it. Here's a link to some screen shots as to what it might look like:http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
Albert is using ListBoxes but you can use Continuous SubForms just as easily.

 

[neileg]

Not obvious what you want. I would have thought that a form/subform setup would be best here. You can have a combo in the main form to select the item and have this populate a continuous subform with the associated drawings. The text boxes in a form have a double click event so you can add code to that so that the user can double click the drawing description in the subform to pop up the relevant drawing. This would be neater than a command button on each record in the subform.

 

[L'apprentis]

Thanks for your replies, I understand what you are saying.
My situation is a bit more complex though, the Continuous form is already a subForm:
The main form is an enquiry form which shows all the different drawing for that enquiry. The subform ( the continuous form ) is linked to an "enquiry Detail Table": The enquiry detail table obviously contains the fields "EnquiryID", "EnquiryDetailID" and "DrawingFileID". I've added the field "ItemId" from "tableItem" in the rowsource of the continuous form and a couple of field from "tableDrawingFile". I am using the continuous form to add drawings to the enquiry.
So, it's seems that I can't use cascading combo box in a continuous Form,
what I could do is to add an unbound form in the form which would allow me to pick a specific drawing and then add it via code to the "tabledrawingfile" which would requery the continuous form, on the after update event of the appropriate ComboBoxe.
I don't know if it makes sense and if I expressed myself very well there but I can't think of anything else to do.

 

[neileg]

I'm more confused, now!

Let's clear one thing up first. Cascading combos aren't an Access object, it's a concept defining a way of working. There's no rule that says you can use them here and not there, it's simply an idea of using the results of an event to provide data for a subsequent event.

Try giving us a screen shot of your form as it stands now. That might help explain things.

 

[L'apprentis]

Here is a snapshot of the form .