Show specific items in combo box for each record in datasheet

[vector39]

Hi everyone



So I have a datasheet in split form view with 6 columns visible and I have a search box that filters as you type based on data that's in all 6 columns (e.g. user types in "smith" and the query looks if this is present in at least one column and gives me back records where this is present in any column(s)). However one of the columns is set as a combo box with several acronyms as items listed. If the user types in e.g. FHP, the datasheet lists all the records that have this in that column. This is fine and all but I was wondering is there a way for me to have it set where if the user types in "FHP" the datasheet would filter but instead of where the combo box only gives me FHP + other acronyms specific to that record? Because how it's currently set, the drop down lists everything in there.

Also is there a way to make this datasheet un-editable? I went into the form property sheet and changed Allow Additions, Allow Deletions to No. But this affected my search bar since as it wouldn't allow me to type anything in. You guys are the best. Thank you!

[Micron]

but instead of where the combo box only gives me FHP + other acronyms specific to that record?

I don't understand this. Can you clarify and/or provide examples?
As for un-editable, you would have to lock or disable all the controls except for the search textbox (bar?) since as you have discovered, setting form properties affects the entire form.

[CJ_London]

cross posted here with further questions https://www.access-programmers.co.uk...d.php?t=294502

@vector - please read this link about cross posting http://www.excelguru.ca/content.php?184

It looks like you have cross posted on a number of previous occasions, but please follow the etiquette advised in the link

[vector39]

Hi

My apologies. I was not aware. I will follow the etiquette for future threads. Thank you

[CJ_London]

it's not a problem - just etiquette.