Search for Record Form for Main Form

[jhergert]

Hello,

With a lot of your help I have gotten familiar with combo boxes and having records in them. But my lists are getting quite long and can be time consuming to find the record that i want to select. I was wondering if it is possible to have a some sort of "pop up" form that when I double click (or other option) on the combo box or text box, come up and can search for a record that way. But then have the record selected in the pop up form transfer to the main form.

I hope I am explaining that well enough.

Thank you in advance.


Josh

[Bob Fitz]

Yes that can be done but, unless I misunderstood your suggestion, I can't see any advantage in scrolling through a form rather than a combo to find the desired record.
You don't ay anything about the records in the combo but, if for example, it contained a list of food items, you could reduce the number of items by having another combo which filters those by categories ie: meat, veg, fruit, fish etc. These are known as "cascading combos".

Can you tell us more about your db and its purpose an/or post a copy of it.

[Micron]

I have no link for this but you can research FAYT (find as you type) combo boxes. As you type in them, they find the list items that match the entered text. That might be more efficient than filtering from a second form.

[Welshgasman]

Here is one link. I use these classes myself.

https://www.access-programmers.co.uk...x-form.327863/

[ArviLaanemets]

As much as I have used combos, whenever I enter the displayed selection item's value manually, Access moves in selection list to RowSource row matching with entered value (in case there exists a value starting this way).

As 1st step, order the combo's row source by column displayed
So let' assume you want to select in compo box "potatoe". There are 2 ways to do this easily:
1. You type e.g. "pota" and then activate combo's lookup list - probably it is activated at selection "potatoe", following e.g. with "pottery" etc. No need to scroll through all possible list values from"a" to "z"
2. You redesign the rowsource of combo so, that displayed values will be like "veg: potatoe". Now when you type into combo "veg", and then activate combo's lookup list, the active item in will be some vegetable, followed by all other vegetables in alphabetical order.

[jhergert]

Thank you for all the help.

Attached is a sample of my database of what i am working on. In the frmStructureAssembly, in the subform under MaterialID, that is where i am wondering if the popup form idea can be used. Right now there are 500+ records in there and it can take awhile to search through them by scrolling.

The end goal is to have this database used by other coworkers who may not know exactly the item number for each material. I was thinking of the pop up form with a search box that can make it easier to see and search for those items. Then select it and have it transfer to the main form.

Thank you again,
josh

[Welshgasman]

You would not search by item number, but by name?

[jhergert]

I would like to search by both item number and name

[Welshgasman]

I would like to search by both item number and name

So combine them into one column?

[Bob Fitz]

I would like to search by both item number and name

perhaps have a combo for each as in the attached db.

[jhergert]

Bob,

THANK YOU!!!, that will work and it keeps it simple. I am very new to the access world, trying to help my employer out with putting this together.

Josh

[jhergert]

What would be the best way to have a keyword search when typing in the description to have the combo box filtered to what you are looking for?

[Bob Fitz]

Bob,

THANK YOU!!!, that will work and it keeps it simple. I am very new to the access world, trying to help my employer out with putting this together.

Josh

You're welcome. Will also need to sort out tab order and enabled/locked properties of controls. See attached

[jhergert]

I know it has been little bit. But thank you again everyone for your help.

I was able to take what you provided and get a pop up to add a record in the subform. I would like to do the same concept but with the main form

I have had good success with an unbound combo box searchforrecord vba and bringing up that record and showing any items related to it in the subform

Fast forward to selecting a record in the pop up form to transfer to the unbound combo box. I am running into a wall on how to get the main form to update with the record selected from the pop up form

Any ideas?

Thank you josh

[Bob Fitz]

I know it has been little bit. But thank you again everyone for your help.

I was able to take what you provided and get a pop up to add a record in the subform. I would like to do the same concept but with the main form

I have had good success with an unbound combo box searchforrecord vba and bringing up that record and showing any items related to it in the subform

Fast forward to selecting a record in the pop up form to transfer to the unbound combo box. I am running into a wall on how to get the main form to update with the record selected from the pop up form

Any ideas?

Thank you josh

Can you post a current copy of the db.