Cascading Combo box on s subform

[wheatlandacctech]

Hello,



I assume there is probably and answer to my question somewhere on this forum but I must not know how to find it. I'm sorry if I'm posting the same question somebody else has already put on here.

I have two combo boxes accountID and subaccountID on a sub form that are both based on tables in a one to many relationship. I want to be able to select a value in the accountID combo box and then have the subaccountID combo box update to reflect the related records in the accountID field. How do I accomplish this? Do I put an expression in the select query on which the row source is based?

I hope my question makes sense. If it's been asked already point me to the related posts.

This YouTube video shows what I want to do, but just on a sub form.

https://www.youtube.com/watch?v=at0uaGSnUco

Thanks,

Joel

[orange]

Example here that may be helpful.
If not, then post your code to the forum.

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...earch/1063673/

[wheatlandacctech]

Thanks for your reply.

I have two tables, one called Accounts with a primary key of accountID and the other one SubAccounts with a primary key of subaccountID and a foreign key of accountID relating it to the accounts table. I then have a main form called Accounts and a subform called SubAccounts. I have two combo boxes on the sub form named accountID and subaccountID. The subaccountID combo box's row source is a select query which has a column for the accountID. In the query on which the row source is based, I have the following code in the criteria row of the accountID column.

[Forms]![frmSubAccount]![accountID]

I don't know if I've given to much information or not enough, but that is the layout of what I've got set up. The crazy thing is that it works fine when I just open of the subform but it won't work as a subform. Where do I go from here?

Thanks,

Joel

[Micron]

@WGM - does the link work for you?

[wheatlandacctech]

No, I couldn't get it to work for me.

Joel

[Micron]

I have a feeling that you're missing the bigger picture. Why people don't seem to post the below link very much any more (and I'm not saying it's just responders here) might be due to just plain being fed up. Anyway, here you go

https://www.excelguru.ca/content.php?184

[mike60smart]

Hi Joel

Remember in the AfterUpdate of the Account Combobox to use:-

Me.cboSubaccountComboboxname.Requery

[Welshgasman]

@WGM - does the link work for you?

Yes, that is just a link to a search for the O/P posts which shows he crossposted within AWF. Take your pick of which one to look at.

[Micron]

Yes, that is just a link to a search for the O/P posts which shows he crossposted within AWF. Take you pick of which one to look at.

Did you try it from your post? This is what I get

Oops! We ran into some problems.

The requested page could not be found.

[Welshgasman]

Did you try it from your post? This is what I get

Oops! We ran into some problems.



The requested page could not be found.

Yes, I used the link from my post.
Just done so again and I get to see the pic attached.?

Perhaps you need to be logged in?

[Micron]

Perhaps you need to be logged in?

That would be it. Kind of makes following it a problem for anyone who's not logged in there or isn't even a member.

[Welshgasman]

That would be it. Kind of makes following it a problem for anyone who's not logged in there or isn't even a member.

TBH, I did not realise?

From now on, I will just link to the crosspost or just one of them, if more than one

O/P is a menber though, and unlike UA, you do not get kicked off every 10 seconds.

[wheatlandacctech]

Yes, I have the AfterUpdate of the Account combobox. All I need is for someone to tell me the correct syntax to reference a control in a subform. I know someone has probably already answered that but I can't find it.

Thanks,

Joel

[Welshgasman]

Yes, I have the AfterUpdate of the Account combobox. All I need is for someone to tell me the correct syntax to reference a control in a subform. I know someone has probably already answered that but I can't find it.

Thanks,

Joel

http://access.mvps.org/access/forms/frm0031.htm