Search as you type - Combo box

[lateral]

Hi June7

Here is a link to the backend


https://www.dropbox.com/s/uwwy0jr1hq...WO_be.zip?dl=0

Here is a link to the frontend

https://www.dropbox.com/s/d44xv1rl3r...ralWO.zip?dl=0

All you need to do is create the following folder and put the front end in it:

c:\RPR Access\

then create the following subfolder called and put the backend into it:

c:\RPR Access\BackEnd

I have attached a few screen shots to get you started but I'm sure you will be able to figure it out.

[June7]

I have the frontend but the backend is too big for my slow internet. You would have to make a copy and delete most of the data.

[lateral]

I can't seem to reduce it much so I will break it into a "spanned" series of zip files that I created using 7-Zip.

I will post the link in a few minutes

Regards
Greg

[lateral]

File 1
https://www.dropbox.com/s/0qhjasoyc6...accdb.001?dl=0
File 2
https://www.dropbox.com/s/mfzu9mko6x...accdb.002?dl=0
File 3
https://www.dropbox.com/s/jover1qiok...accdb.003?dl=0
File 4
https://www.dropbox.com/s/zrb7fuahjd...accdb.004?dl=0
File 5
https://www.dropbox.com/s/rw9iqhamth...accdb.005?dl=0
File 6
https://www.dropbox.com/s/ur9fwbje04...accdb.006?dl=0
File 7
https://www.dropbox.com/s/9yuqzueh6n...accdb.007?dl=0
File 8
https://www.dropbox.com/s/ysumnrn3yh...accdb.008?dl=0
File 9
https://www.dropbox.com/s/5gl9ez2tww...accdb.009?dl=0
File 10
https://www.dropbox.com/s/cmlmutmccn...accdb.010?dl=0

[June7]

I can't open 7-zip files, only Windows Compression zip.

Unless someone else wants to tackle this, or explain the issue so I can understand it, I guess you are on your own.

I am still not sure you really answered my question about purpose of the combobox. From what I can see in the images, the Part Name combobox is bound to field. This means the combobox is for data entry, not for just selecting filter criteria.

I looked again at the code in post 6. It doesn't make sense for a combobox RowSource to have criteria that refers to itself. It also refers to PartsID and PartID.

I see two comboboxes bound to the same field - PartID - which also doesn't make sense.

Every time I look more closely I get more confused.

[lateral]

Hi June7

Yes, the combo box is for "data entry" as it allows the user to select a part from the Parts table to add to the workorder....

Thanks for your help so far.

Regards
Greg