Selecting records on a form froma combi box

[merry_fay]

Hi,

I have a combi box on my form for one field where the value can be repeated
& I'm trying to make it so when a value is selected, all the records with
that value are shown, but can't seem to get them to do that -I can change the
combo box, but the list of records doesn't update -what do I need to do?

Thanks
MerryFay

 

[Tom Wickerath]

Hi MerryFay,

Is your combo box on a main form, with the records that you wish to display
in a subform? If so, you should be able to achieve what you need by setting
the Link Master Field of the subform control (the control that holds the
subform) to the combo box, and the Link Child Field property to the
appropriate field that serves as a foreign key. The bound column of the combo
box will need to be the associated primary key (unless you want to use the
..columns property of the combo box to refer to a different column).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[merry_fay]

Hiya,

No, it's all in one form. The combo box is in the footer & then the rest of
the details of the records are in the main section.
I need to get these records in the main section to update when I change the
combo box without using a subform

Thanks
MerryFay

 

[Tom Wickerath]

Hi MerryFay,

I'm not sure of what method you have implemented in an attempt to achieve
this functionality. However, you might want to give Access MVP Allen Browne's
method a try:

Find as you type
http://allenbrowne.com/AppFindAsUType.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________