Attach search selection to other data locations in a form

[bbelly]

I'm trying to migrate from Excel to Access (2016). My library list has exceeded 15,000 records, and Excel doesn't seem right for it.

I have a 'search while typing' combo box / text box setup. (http://www.opengatesw.net/ms-access-...pe-Access.html). I couldn't figure out how to change fields within it, so I changed my field titles from TITLE to FIRST (name) & YEAR to LAST (name).

So now, when I search and select from that, I need the rest of the form to reflect the relevant data, such as LENGTH, AUTHOR, LANGUAGE, etc.

Would appreciate a point in the right direction.

[June7]

You changed your field names to match the code???? That was a big mistake. Did you also change your table names to match the code? Finding the names in code is really simple. You must have found them to even know what to change yours to.

If you are using the code in the article, what happens - error message, wrong results, nothing? If the form is bound to table with the data, then it should display data.

Hope fields are not named FIRST and LAST - these are reserved words. Also, advise no spaces or punctuation/special characters (underscore only exception). Better would be First_Name or FirstName.

[bbelly]

>

You changed your field names to match the code???? That was a big mistake. Did you also change your table names to match the code?
> Finding the names in code is really simple. You must have found them to even know what to change yours to.

I could not (initially) find any reference to FIRST or LAST in the code. I have since found another window of code that does have reference to FIRST and LAST. I can make that a bit better now.

> If you are using the code in the article, what happens - error message, wrong results, nothing?
> If the form is bound to table with the data, then it should display data.

The search function returns the answer I expect. What I would like to do is have the rest of the fields be populated with the data belonging to the selected record. (I simply pasted my database in place of the original table - and that generated the correct additional fields for my more extensive data.)

> Hope fields are not named FIRST and LAST - these are reserved words. Also, advise no spaces or punctuation/special characters (underscore only exception).
> Better would be First_Name or FirstName.

The names were in the original sample. I am familiar with the naming conventions (I think error traps catch bad ones¿)

Thanks for taking the time to ask the questions that clarify the situation.

[June7]

The search function returns the correct value in the combobox?

Is the combobox bound to field and purpose is to save value in record? Or is combobox unbound and purpose is to select criteria to filter form?

If the first then make the combobox multi-column and include the other fields from the lookup table (they can be hidden if you prefer). Then expression in textbox can refer to the columns by index. Index begins with 0. So if the LENGTH (maybe another reserved word) is in column 2, its index is 1: =[comboboxname].[Column](1)

[bbelly]

So far so good !
Changed the names to TITLE and YEER (year) (Would be cool to change combo box heading to proper 'Year', but ... baby steps)
And got a text box to reflect data from my selection. YAY!
I'll work out the details of this, but I will likely be back.
Question lurking right now is how to set this form up to accept a new record (but I'll give it the old college try on my own).

Thanks for the help!