combo box linked to sub form

[gbmarlysis]

Hi,
i have a combo box on a form, i want a subform to show all the athletes races when i pick the athlete from th combo box. in properties of the subform it only lets me link to tables or queries..
TY
LB

 

[MStef]

I think you need something like "Demo" a new one.
Open "frmAthleteMain" and try.
I added a combo box on the Top of the form.
Look at VBA.

 

[gbmarlysis]

Hi Stef
thankyou for the example, do you think it will work if the subform is connected to a combo box that isnt the table connected to the main form.
i wish i could understand that code....how did you learn. i feel like i've been humbled..
TY
LB
i would upload my file but i cant for some reason

 

[gbmarlysis]

Hi Stef
Here is the file i hope
,View attachment athlete db (2).zip

 

[MStef]

Look at my "Demo" a new one.
Look at Word "SubormSingle", (below).
Open a "frmRacesSubormSingle" and try.

 

[MStef]

Here is a word (attachment, zip).

 

[gemma-the-husky]

i doubt if you can auto-link a subform to an unbound combobox

you need to base the subform on a query that refers to the combobox

then in the afterupdate event of the combobox, you just do

subdetails.requery