Access table value using lookup wizard; assign values; allow multiple values; trouble in the form.

Bound Column = 1

Row Source is list as added in the table field lookup values

Column count = 1

I could post the table on OneDrive.

Short text is the datatype

Value list is made of category names.  

In the

field called value list, the list names look like this.

"Batters"; "Pies"; etc.  as this is a recipe table.

In the datasheet form,when the control is opened, a dialog box drops with value list items along with a check box on the left.  The check box accepts a check on one or multiple value list items.  However when the OK button is checked no action occurs.  the dialog box stays open and the OK button is highlighted. 

When I open another record category field, no text is displayed in the record that I just left.  Upon checking the "category" field in the table, I find that it is empty. 

I could send you a link to my onedrive account with the table and form.  I would really like to resolve this.

Here is a jpg of my table lookup field programming.  

Thanks for your help.

Gary

Thank you for your input. 

The value list is for a short static use.  They are categories not ingredients.  In some cases the recipe may be in more than one category.  Thus the reason for the need of multiple values in the category field.

The four number price field are used in conjunction with an ancient Point of Sales system, aschii supported.  Micros 2700. 

These reasons may not be best for normalization but they work for my situation. 

However, as you said, these items do not solve my problem.  I have uploaded a very brief version of the database front end and back end for your review.  Both of these files are in my mapped network folder -  F:\PMAccess\   The back end needs to be there for the program to launch.

I left the database as a split system so that you may see exactly what I am working with.

The one drive link is: https://1drv.ms/f/s!AvdwD25muh4jhVlztXnHt3i7lwtk

Thanks again for your support.

Gary

Thanks Scott.

I will do those things even though I do not think that it will help.  

Before sending you the link, I downloaded the two files from my One Drive account into my wife's Windows 10 computer running access 2016.  I created a mapped drive f:\PmAccess and transferred the files to that location.  

I opened the PM.accdb file and then opened the Category field on the frmRecipes datasheet.  I found the same problem.   It is a different computer with a different Access program.  

Again my problem looks like this.

A dialog box opens with my value list vertically arranged.  A check box to the left of each value item which accepts and displays the check in the box.  The bottom of the dialog box has two buttons; one is OK and one is Cancel.  When I check the OK button, there seems to be a color change and a highlighting indication.  The box does not close.  When I move to a different record, the box closes but there is not content in the form control or the table field.

In your tests, how is it different?

Thanks Gary