Comboboxes in continuous form

[KuaiLe!]

Hello, I have a combobox in a subform. These are two separate records but they have the same information in the subform on the right. I would like to have each member record have their own individual subform data. Would this be possible? Thank you.

 

[theDBguy]

Hi. Welcome to AWF!

Did you set up the Master and Child Link Fields properly?

 

[GPGeorge]

Hello, I have a combobox in a subform. These are two separate records but they have the same information in the subform on the right. I would like to have each member record have their own individual subform data. Would this be possible? Thank you.

Can you show us this form in design view as well? This is hard to understand from what is visible in this screenshot.

 

[mike60smart]

Hello, I have a combobox in a subform. These are two separate records but they have the same information in the subform on the right. I would like to have each member record have their own individual subform data. Would this be possible? Thank you.
View attachment 114337View attachment 114338

Hi
Welcome to the Forum.
Can you upload a zipped copy of the database?

 

[MajP]

I am curious of how the OP did this. This looks like a from in continuous view with an embedded subform. This would be very cool if you can do this but AFAIK this cannot be done. You get a some message like "A form with its default view set to continuous cannot have an embedded subform".

 

[GPGeorge]

I am curious of how the OP did this. This looks like a from in continuous view with an embedded subform. This would be very cool if you can do this but AFAIK this cannot be done. You get a some message like "A form with its default view set to continuous cannot have an embedded subform".

I think it might be two embedded subforms, one on the left and another on the right. That's why I want to see the form in design view.

 

[Gasman]

I think it might be two embedded subforms, one on the left and another on the right. That's why I want to see the form in design view.

Or even better, upload a sample db :-(

 

[Pat Hartman]

@MajP One of my clients did it this way. Main form, continuous subform, continuous subform in the footer of the continuous subform. It seems to work OK.

 

[MajP]

I see that I was tricked. That is not two records in continuous view with a subform next to each record, but actually two separate images posted one on top of the other. Both images are a main form in single form view with a subform. I thought Access had some new capability which would be valuable. AFAIK the best you can do to display a continuous form with an embedded continuous form is a subdatasheet

Opinions on form design

I see. Thank looks soo much simpler than messing with a tree view. Thanks MajP!

www.access-programmers.co.uk

 

[Pat Hartman]

AFAIK the best you can do to display a continuous form with an embedded continuous form is a subdatasheet

Did you look at the image I posted. It does show the second subform in the first subform's footer. I'm not sure I would ever do that. I think the forms look too busy. Also, the footer doesn't expand so it is very limited. I ended up changing the second subform to a popup to reduce the size of the main form so that it didn't have to scroll. I HATE forms that don't fit entirely on the screen and I'm not talking about records in s subform that scroll. In that case, you see the entire subform and it is clear that you can scroll to see more rows. When the main form doesn't fit on the screen, the user may not even notice that something is missing.

I only mention it because if the second subform is very limited, then the fixed height of the footer won't be a problem. OR, you can write code to change the footer height on the fly.