Gallery selection not auto populating EditForm screen

[Johnafin]

Hello. I have an excel table database I am using and I ran into a problem.

I have a Gallery that has a search bar filter on it and the Edit screen will not auto populate what I selected. The only information being held is the text entry.

Here is the filter that is on the Gallery Item

Search(Dock, TextSearchBox1.Text, "Dock_x0020_or_x0020_Yard","Completed")

And the edit selection Item is 

BrowseGallery1_1.Selected

I understand the filter on the Gallery is messing up the records, but even then, why would my dropdowns not populate with a different record's information?

Any help would be greatly appreciated. Thank you!

[Drrickryp · Accepted solution]

Hi @Johnafin 

If you have modified the Items of the gallery, you will need a more specific way to identify the record chosen for the edit form.  Instead of the Item property of the form: BrowseGallery1_1.Selected  try

Lookup(Dock,ID=BrowseGallery1_1.Selected.ID)

 You did have an ID column in your table, didn't you?